Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL » Interactive SQL options

isql_maximum_displayed_rows option [Interactive SQL] Next Page

isql_plan option [Interactive SQL]


Function

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

Allowed values

SHORT, LONG, GRAPHICAL, GRAPHICALLOWDETAIL, GRAPHICALHIGHDETAIL

Default

GRAPHICAL

Description

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:

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.

See also