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