ASA Database Administration Guide
Database Options
Alphabetical list of options
Controls the amount of information that appears on the Plan tab and the UltraLite Plan tab in the Results pane after you execute statements.
SHORT, LONG, GRAPHICAL, GRAPHICALWITHSTATISTICS, NONE
SHORT
After you execute a SQL statement in Interactive SQL, the optimizer provides information about how it optimized the execution on the Plan tab. To set the level of detail for the plan the optimizer provides, you can choose one of the following values:
SHORT provides basic information about the optimizer plan.
LONG provides detailed information about the optimizer plan.
GRAPHICAL provides a tree diagram of the query. You can click on a node in the plan diagram to see details about that part of the query.
GRAPHICALWITHSTATISTICS provides a tree diagram of the query, as well as statistics which indicate the resources used by the part of the query that is selected. The UltraLite plan treats this value the same as the GRAPHICAL value.
NONE means no optimizer information can be accessed. This parameter is deprecated.
The plan is computed only when you click the Plan tab.
You can also specify the plan type on the Plan tab of the Options dialog.