To obtain Index Consultant recommendations for a query (Sybase Central)

1. Open Sybase Central.

2. Connect to the database as a user with DBA authority or as a user with PROFILE authority.

3. Right-click the database and choose Open Interactive SQL.

4. In the SQL Statements pane, type the query.

5. Choose Tools » Index Consultant.