Index Fundamentals

The end goal of this book is to help you improve the performance of your databases through the use of indexes. Before we can move toward that end, we must first understand what indexes are and why we need them. We need to understand the differences between how information on a clustered index and heap table is stored. We’ll also look at how nonclustered and column store indexes are laid out and how they rely on other indexes. This chapter will provide the building blocks to understanding the logical design of indexes.

Why Build Indexes?

Databases exist to provide data. A key piece in providing the data is delivering ...

Get Expert Performance Indexing for SQL Server 2012 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.