[ankurk]

Hi plz tell me where are the cursors created in RAM... i mean is it in shared pool or any where else..

Secondly what are the steps invloved when we issue a query select invloving order by clause....


Thanks

[venkatesanj@hcl.in]

Yes if we try to execute any program, the execution will happen in the RAM. Cursors will stay in the ram but in a seperate sql server application domain.

Cursors are heavy weight objects too.

Regards,
Venkatesan Prabu. J

[venkatesanj@hcl.in]

If we issue select statement with order by clause,

My database engine will search for the table in the database using the hierarchy

Servername.Database name.Database owner name.Table name

The second step is identifying the columns with filter criteria.

The final step is ordering the data retrieved based on the order by clause.

Regards,
Venkatesan Prabu. J