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