|
The Plan tab of the Options dialog in Interactive SQL has the following components:
Plan These options allow you to select the level of detail Interactive SQL provides about the way your query is optimized. 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 a node in the plan diagram to see details about that part of the query. This plan is the default.
Graphical plan with root statistics The execution plan is displayed as a tree diagram in the Plan tab, and you can click a node to see details about that part of the query. Statistics are also displayed in the root node which indicate the resources used during execution of the entire query.
Graphical plan with full statistics The execution plan is displayed as a tree diagram in the Plan tab, and you can click a node to see details about that part of the query. Statistics are also displayed which indicate the resources used during execution 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 execution 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.
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.
See: