Microsoft® SQL Server 2005 Unleashed

Chapter 29. Indexes and Performance

IN THIS CHAPTER

• What’s New for Indexes and Performance

• Understanding Index Structures

• Index Utilization

• Index Selection

• Evaluating Index Usefulness

• Index Statistics

• SQL Server Index Maintenance

• Index Design Guidelines

• Indexed Views

• Indexes on Computed Columns

• Choosing Indexes: Query Versus Update Performance

There can be a number of reasons why SQL Server performance might be less than optimal, but in many cases, it comes down to poor index design or simply a lack of appropriate indexes. You can often realize substantial performance gains in SQL Server based applications by creating the proper indexes to support the queries and operations being performed in SQL Server. The great benefit here is that the applications immediately ...