ASA SQL User's Guide
Query Optimization and Execution
Reading access plans
Accessing the plan
The following types of plan are available in Interactive SQL:
Short plan
Long plan
Graphical plan
Graphical plan with statistics
To choose the type of plan you want to see, click Tools
To see the plan, execute a query and then open the Plan tab. The Plan tab is located at the bottom of the Interactive SQL window.
You can also view the UltraLite plan for your query. The UltraLite plan does not include statistics.
To view the UltraLite plan in Interactive SQL, open the Options dialog from the Tools menu and select Show UltraLite Plan. This option is selected by default. You control the UltraLite plan type by selecting one of the types above (graphical, short plan, or long plan). If you choose graphical plan with statistics, you get the graphical plan.
The UltraLite Plan tab appears at the bottom of the Interactive SQL window. For some queries, the UltraLite execution plan may differ from the plan selected for Adaptive Server Anywhere.
For more information, see GRAPHICAL_ULPLAN function [Miscellaneous].