© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_4

4. Special Indexing and Storage Features

Dmitri Korotkevitch

(1)Tampa, Florida, USA

This chapter discusses several storage- and indexing-related features available in SQL Server. It covers indexes with included columns, filtered indexes and statistics, data compression, and sparse columns.

Indexes with Included Columns

As you already know, SQL Server rarely uses nonclustered indexes when it expects that a large number of Key or RID lookupsis required. Those operations usually lead to a large number of reads, both logical and physical.

With key lookup operations, SQL Server accesses multiple data pages from different levels in a clustered index every ...

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.