Sybase IQ Execution Plan View Options

Table 1. Sybase IQ execution plan view options
Property	Description
Show Plan While Executing SQL Statements	Show the query plan in the Execution Plan view while executing SQL statements, for text plans only. You see actual statistics as the query executes. For graphic plans, the query must execute to show the plan. Whether you select this option or not, you can get an execution plan from the SQL Editor with estimated statistics.
ASA Style Query Plan	Short Description compares plans quickly. Long Description provides slightly more information than the short description and is easy to print and view. Graphic Plan displays the execution plan in graphic format. Graphic Plan with Statistics is similar to the graphics plan but also displays actual runtime costs of executing the statement. Ultralight Short Description Ultralight Long Description Ultralight Graphics Plan
Sybase IQ Style Query Plan	Display a Sybase IQ style query plan for SQL. This property is selected by default. An HTML-based query plan is the only query plan type available for this property.

Table 2. Sybase IQ Style Query Plan Options
Property	Description
Show Query Plan Detail	Display additional information about a query when producing its query plan. This property is selected by default.
Show Query Plan After Run	Print the query plan when the query has finished running, which enables the query plan to report additional information, such as the number of rows passed from each node of the query. This property is selected by default.
Show Query Timing Section	Show timing information for query execution.
Index Advisor	Use the Index Advisor.
No Exec	Generate the query plan without executing the query. Only available for non-data-update queries.

Table 3. Get Query Plan
Property	Description

Retrieve Query Plan by SQL Function	Retrieve query plan using HTML_PLAN() function. Only available for Sybase IQ 12.7 ESD#3 and later. This option is selected by default for Sybase IQ 15.x.
Remote Sybase IQ Server Plan Files Location	Use a shared folder to retrieve query plan. Enter the location of the query plan files for a remote Sybase IQ server as a remote directory path, for example: \\remote-server\Sybase