ASA SQL User's Guide
Working with Database Objects
Working with indexes
The Index Consultant guides you in the proper selection of indexes. You can use the Index Consultant in the following ways:
Interactive SQL You can use the Index Consultant from Interactive SQL to analyze the benefits of indexes for an individual query.
Sybase Central You can use the Index Consultant from Sybase Central to analyze the benefits of indexes for a workload, or set of database requests.
To start the Index Consultant (Sybase Central)
In the left pane of Sybase Central, right-click the Indexes folder.
From the popup menu, choose Index Consultant.
To start the Index Consultant (Interactive SQL)
Enter a query that you wish to analyze into the SQL Statements pane of Interactive SQL.
Choose Tools