Chapter 12. Creating Indexes for Performance
Indexes are a Microsoft SQL Server feature designed to speed access to data in the database. Indexes are similar to the index of this book. By using indexes, you can quickly find specific data without having to read through all of the data in the table. In this chapter, you will learn what indexes are, how they work, and what you can do to improve performance on your system by using indexes. In addition, you will learn about the new index features in SQL Server 2005.
Index Fundamentals
Indexes are an optional structure that is designed to help you access table data ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
