Non-Indexed Performance

Indexed Performance

Figure 1. Fine-Tune Your Queries. You can use the Index Tuning Wizard to analyze your queries and suggest possible indexes, but you should be careful when you do this because it can affect other parts of your database adversely.