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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Improving database performance » Index Consultant

 

Obtain Index Consultant recommendations for a query

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.