Free SQL Server: Optimizing Database Performance Through Indexes Tutorial

“>Appropriate indexes are a necessary part of any successful databaseapplication. In fact, you can see performance improvements of 10, 100, andsometimes even 1,000 fold by adding helpful indexes to your database tables.This article introduces the basics of clustered and non-clustered indexes, andgives you some ideas and tips for selecting a proper indexing strategy.Indexes 101Simply put, an index is a physical structure containing pointers tothe data. SQL Server 2000 supports up to 25 
continue >>