O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

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

© Dmitri Korotkevitch 2016

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

2. Tables and Indexes: Internal Structure and Access Methods

Dmitri Korotkevitch

(1)Tampa, Florida, USA

SQL Server stores data in tables and indexes. They represent a collection of data pages with rows that belong to a single entity or object.

By default, the data in tables is unsorted. You can store it in sorted order by defining a clustered index on the table. Moreover, you can create nonclustered indexes that persist another copy of the data from the index columns sorted in a different order.

In this chapter, we will talk about the internal structure of the indexes, cover how SQL Server uses them, and discuss how to write queries in a way that ...

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