Generating Index Advice Using the Index Advisor

Use the Index Advisor to apply any existing index advice when creating an index for a Sybase IQ table.

Prerequisites

Be sure the data server for which you are creating an index is running, and you created and established a connection to the data server.

In Enterprise Explorer, right-click the Indexes folder and select Index Advisor.
If you receive the message No Index Advices Found, you can invoke the Index Advisor from the New Index wizard by clicking Index Advisor. Use the No Index Advices Found wizard to enable the Index Advisor and to generate index advice items.

Generate index advice items.

Table 1. No index advices found
Option	Description
Clear Index Advice Storage	Clear the storage for the Index Advisor. This option appears only if the Index Advisor is already enabled.
Index Advisor Option	Enable the Index Advisor, and choose either temporary or permanent (default). This option appears only if the Index Advisor has not been enabled.
Maximum Number of Unique Advices	Set a temporary or permanent maximum, and specify a number in the corresponding text field. The default is 30.
Input SQL to Generate Index Advices	Click SQL to open Visual SQL and construct a query.

(Optional) Reinvoke the Index Advisor.

If the Index Advisor was invoked from a table in Enterprise Explorer, the Index Advisor displays advice items for the specified table. If the Index Advisor was invoked from a schema folder, the Index Advisor displays advice items for the entire schema.

Table 2. Index advice item fields
Field	Description
Table	The table on which the index is defined.
Type	The index type: HG – high group (default) HNG – high non-group Date Time CMP – compare WD – word DTTM – date-time LF – low fast
Column	The column on which the index is defined.
Advice	The advice for this index.

Select one or more advice items from the Index Advisor.
Click Apply to apply the index advice item or items to the specified index.
You can clear the index advice by right-clicking the Indexes folder or an index, and selecting Clear Advisor.