How to analyze a query using Index Analysis (Query Analyzer)
To start the Index Tuning Wizard
- Expand a server group, and then expand the server in which to create the index.
- On the Tools menu, click Wizards.
- Expand Management.
- Double-click Index Tuning Wizard.
- Complete the steps in the wizard.