How To: Optimize SQL Indexes

How To: Optimize SQL Indexes

Improving .NET Application Performance and Scalability
J.D. Meier, Srinath Vasireddy, Ashish Babbar, and Alex MackmanMicrosoft Corporation
May 2004
Related Links
Home Page for Improving .NET Application Performance and Scalability
Chapter 12, Improving ADO.NET Performance
Chapter 14, Improving SQL Server Performance
Checklist: ADO.NET Performance
Checklist: SQL Server Performance
Send feedback to Scale@microsoft.com
patterns & practices Library
Summary: This How To describes an approach for optimizing table indexes to increase query performance. During the process, you use Structured Query Language (SQL) Profiler, Index Tuning Wizard, and SQL Query Analyzer to identify problems and analyze solutions.