Where are cursors created?

ankurk's Avatar, Join Date: Aug 2007
Go4Expert Member
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's Avatar
Go4Expert Member
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's Avatar
Go4Expert Member
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