Cursor in SQL Query

[Former Member]

Dear All ,

Can the performance of the select query be improved with the help of Database Cursor?

Please Suggest.

Regards,

Nikhil

[ThomasZloch]

I dare say no, it is a sort of database internal pointer to the rows of the result set of your query, something you normally need not worry about as a programmer using Open SQL in ABAP (unless you illegally interrupt it...). Better concentrate on reading less data with more efficient index usage.

Actually what is the practical relevance of your question?

Thomas

[Former Member]

what should be the help of the cursor ... do you want to guide it?

Don't get confused by the cursur column in the SQL-trace, it is only the reference to the cursor cache, the place where

the execution plan is stored.

[RaymondGiuseppi]

Look at <a class="jive-link-external" href="http://help.sap.com/abapdocu_70/en/ABENOPEN_SQL_PERFO.htm" target="_newWindow">Open SQL - Performance Note</a><br />

<br />

You reduce the task of opening/closing cursor with individual or nested select.<br />

<br />

Regards,<br />

Raymond