Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Using the Index Consultant

The Index Consultant guides you in the proper selection of indexes. You can use the Index Consultant to obtain a set of index recommendations for an individual query, or for an entire database.

To obtain index recommendations for a single query, access the Index Consultant from Interactive SQL.

To obtain Index Consultant recommendations for a query

1. In Interactive SQL, type the query in the SQL Statements pane.

2. Choose Tools > Index Consultant.

   The Index Consultant performs its analysis and returns recommendations.

Obtaining index recommendations for a database

To obtain Index Consultant recommendations for an entire database, use the Application Profiling wizard in Sybase Central. This is the easiest way to obtain Index Consultant recommendations.

To obtain Index Consultant recommendations for a database

1. Connect to the database you want Index Consultant to analyze as the DBA.

2. Choose Mode > Application Profiling.

3. If the Application Profiling wizard does not automatically start, choose Application Profiling > Open Application Profiling wizard.

4. Follow the instructions in the wizard, including running your applications for a period of time in order to capture tracing information.

5. When you are done capturing data, click Finish in the Application Profiling wizard.

6. Choose Application Profiling > Run Index Consultant on Tracing Database.

   The Index Consultant appears.

7. Follow the instructions provided in Index Consultant.

   The Index Consultant analyzes the tracing data and returns its recommendations. For more information about Index Consultant recommendations, see Understanding Index Consultant recommendations.