The name of a declared cursor is now logged in the detailed query plan, as shown in the following sample output:
I. 03/21 11:59:44. 0000000002 [20535]: Est. Temp Space Used (Mb): 0.0 I. 03/21 11:59:44. 0000000002 [20535]: Cursor Name: resultcursor I. 03/21 11:59:44. 0000000002 [20535]: Requested attributes: Scroll Chained I. 03/21 11:59:44. 0000000002 [20535]: Effective Number of Users: 1
Since all queries are executed as cursors, a query that does not have a user-specified cursor name is assigned an internal cursor name by IQ. You may see internal cursor names like “AAAAAAA” and “BAAAAAA” in the query plan.
Refer to Chapter 3, “Optimizing Queries and Deletions” in the Sybase IQ Performance and Tuning Guide for more information on query plans.
