Chapter 18. Understanding Indexes
by Mark Spenik
IN THIS CHAPTER
General Principle Behind Indexes
Structure of SQL Server Indexes
Data Modification and Index Performance Considerations
How to Create Indexes
Other Index Operations
Suggested Index Strategies
Letting SQL Server Help with Index Selection
Index FAQ
You might wonder what a chapter on indexes and index selection is doing in a book about database administration. For a DBA, it is important to understand how SQL Server uses indexes and how they can be used to enhance performance. For example, developers always come to the DBA seeking words of wisdom and advice for slow applications or queries. Not only will index tuning knowledge elevate you in their eyes, but also a working knowledge of indexes ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
