Sybase IQ Execution Plan View Options

Set Sybase IQ execution plan view options to specify defaults for viewing IQ query plans.

Table 1. Sybase IQ execution plan view options: General
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 property or not, you can get an execution plan from the SQL Editor with estimated statistics.

Table 2. Sybase IQ execution plan view options: Query Plan Style
Property Description
ASA Style Query Plan Display an ASA style query plan for SQL. Choose a plan type:
  • Short Description
  • Long Description
  • Graphics Plan
  • Graphics Plan with Statistics
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 3. Sybase IQ execution plan view options: 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.
Table 4. Sybase IQ execution plan view options: Remote IQ server plan files location
Property Description
Files Location Enter the location of the query plan files for a remote Sybase IQ server as a remote directory path, for example:

\\remote-server\Sybase

Related concepts
Execution Plans
Execution Plan View
Related tasks
Obtaining an Execution Plan
Creating a Graphic Execution Plan
Creating a Text Execution Plan
Related reference
Execution Plan View Options
ASE Execution Plan View Options
ASA Execution Plan View Options

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com