SQL Anywhere Studio Help
Interactive SQL Help
Options dialog
The Plan tab of the Options dialog in Interactive SQL has the following components:
Execution plan options These options allow you to select the level of detail Interactive SQL provides about the way your query is optimized, select a plan type from the list of plan types. Plan information appears on the Plan tab in the Results pane.
Graphical plan The execution plan is displayed as a tree diagram in the Plan tab. You can click on a node in the plan diagram to see details about that part of the query. This plan is the default.
Graphical plan with statistics The execution plan is displayed as a tree diagram in the Plan tab, and you can click on a node to see details about that part of the query. Statistics are also displayed which indicate the resources used by the part of the query that is selected.
Short plan Basic information about an execution plan appears in one line on the Plan tab in the Results pane. This line lists the table(s) accessed and whether the rows are to be read sequentially or accessed through an index.
Long plan Detailed information about an execution plan appears in multiple lines on the Plan tab.
For more information about the different types of execution plans, see Accessing the plan in Interactive SQL.
Assume read-only cursor Select this option if you want the query optimizer to treat the query as if it had been executed for a read-only cursor. By default, this option is not selected, indicating that the optimizer should get the plan for a read-write cursor.
For more information, see PLAN function [Miscellaneous].
Assume cursor is You can obtain a plan based on the type of cursor you specify. The query optimizer can assume the cursor is Asensitive, Insensitive, Sensitive, or Keyset-driven. The default is Asensitive.
For more information, see PLAN function [Miscellaneous], Asensitive cursors, Insensitive cursors, Sensitive cursors, and Value-sensitive cursors.
Show UltraLite plan Select this option if you want the UltraLite plan to appear on a separate tab in the Results pane in Interactive SQL.
You control the UltraLite plan type by selecting one of the types above (Graphical, Graphical Plan With Statistics, Short Plan, or Long Plan). This option is selected by default.
For more information, see GRAPHICAL_ULPLAN function [Miscellaneous], LONG_ULPLAN function [Miscellaneous], and SHORT_ULPLAN function [Miscellaneous].
Accessing the plan in Interactive SQL