SQL Anywhere® Server - Database Administration  > SQL Anywhere Administration Tools  > Interactive SQL  > Interactive SQL options

isql_plan option [Interactive SQL]

Controls the type of access plan that appears on the Plan tab in the Interactive SQL Results pane after you execute statements.

SHORT, LONG, GRAPHICAL, GRAPHICALLOWDETAIL, GRAPHICALHIGHDETAIL

GRAPHICAL

This option allows you to specify the type of access plan that appears for SELECT, INSERT, UPDATE, and DELETE statements. 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 access plan.

• LONG  Provides detailed information about the access plan.

• GRAPHICAL  Provides a graphical plan with no statistics.

• GRAPHICALLOWDETAIL  Provides a tree diagram of the query with statistics for the root node of the query.

• GRAPHICALHIGHDETAIL  Provides a tree diagram of the query, as well as statistics that indicate the resources used by the part of the query that is selected.

The plan is computed only when you click the Plan tab.

You can also specify the plan type on the Plan tab of the Interactive SQL Options dialog.

Note that the access plan that appears may not be the same plan that was used when the statement was executed. The plan is fetched after the SQL statement is executed, at which point the optimizer may have new information available. This means that the optimizer may return a different plan than the one it used to execute the statement.

• SET OPTION statement [Interactive SQL]