Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 12.0.0 (Français) » 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. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or PROFILE authority.

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

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

  4. Choose Tools » Index Consultant.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0