Using the Index Advisor

Use the Index Advisor to apply any existing index advice when creating an index for a table in Sybase IQ 12.7. Attempts to invoke the Index Advisor for earlier releases of Sybase IQ result in an error message.

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.

  1. Invoke the Index Advisor for a Sybase IQ 12.7 data server by right-clicking the Indexes folder under a table profile and choosing Index Advisor.

    Alternately, you can invoke the Index Advisor from the New Index wizard by clicking Index Advisor.

    If there is no existing index advice and you invoke the Index Advisor from the Enterprise Explorer context menu, WorkSpace informs you that there is no index advice. If there is no index advice and you invoke the Index Advisor from the New Index wizard, the No Index Advices Found wizard opens. Use the No Index Advices Found wizard to enable the Index Advisor, if it is not already enabled, and to generate index advice items.

  2. Generate index advice items.
    Table 1. No index advices found
    Field 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.

    Index advice items are generated using the supplied queries.

  3. (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.
  4. Select one or more advice items from the Index Advisor.
  5. Click Apply to apply the index advice item or items to the specified index.
Related tasks
Creating an Index for a Sybase IQ Table
Editing an Index for a Sybase IQ Table
Dropping an Index for a Sybase IQ Table

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.