Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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.