Contents Index Debugger Java Source dialog Interactive SQL Help

SQL Anywhere Studio Help
  Adaptive Server Anywhere Help

Index Consultant


The Index Consultant guides you in the proper selection of indexes for your database. It guides you through the process of selecting indexes for a single query or for a set of database requests (called a workload). It creates many different sets of virtual indexes. For each set, the Index Consultant optimizes queries and other requests as if those virtual indexes were present. The Index Consultant then gathers the results of these explorations into a set of recommendations.

See also 

Index Consultant overview

Understanding the Index Consultant

Understanding workloads

Understanding the analysis

Understanding the recommendations

Assessing the recommendations

Implementing the recommendations


Contents Index Debugger Java Source dialog Interactive SQL Help