topic Re: Cursor in SQL Query in Application Development and Automation Discussions

Cursor in SQL Query

Former Member — Thu, 29 Oct 2009 04:38:52 GMT

Dear All ,

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

Please Suggest.

Regards,

Nikhil

Re: Cursor in SQL Query

ThomasZloch — Thu, 29 Oct 2009 08:27:01 GMT

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

Re: Cursor in SQL Query

Former Member — Fri, 30 Oct 2009 13:48:44 GMT

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.

Re: Cursor in SQL Query

RaymondGiuseppi — Fri, 30 Oct 2009 13:59:35 GMT

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>

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

Regards,

Raymond