Contents Index Accessing the plan Accessing the Plan with SQL functions

ASA SQL User's Guide
  Query Optimization and Execution
    Reading access plans
      Accessing the plan

Accessing the plan in Interactive SQL

The following types of plan are available in Interactive SQL:

To choose the type of plan you want to see, click Tools > Options and select the Plan tab.

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.

UltraLite plan 

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].


Contents Index Accessing the plan Accessing the Plan with SQL functions