Contents Index ISQL_LOG option [ISQL] ISQL_PRINT_RESULT_SET option [ISQL]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ISQL_PLAN option [ISQL]


Function 

Controls the amount of information that appears on the Plan tab and the UltraLite Plan tab in the Results pane after you execute statements.

Allowed values 

SHORT, LONG, GRAPHICAL, GRAPHICALWITHSTATISTICS, NONE

Default 

SHORT

Description 

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.


Contents Index ISQL_LOG option [ISQL] ISQL_PRINT_RESULT_SET option [ISQL]