http://www.sqlservercentral.com/Articles tagged SQL Server 2005, Performance Tuning, Indexing posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch.http://www.sqlservercentral.com/redirect/articles/61605/2007/12/04http://www.sqlservercentral.com/redirect/articles/61605/