O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required