O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

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

Tools for analyzing indexes

To help you understand index structures fully, this section uses a few tools whose appropriate use you need to get a feel for. This section also focuses on an overview of the options for execution, as well as some tips and tricks. The details on analyzing various aspects of the output can be found throughout this chapter.

Using the dm_db_index_physical_stats DMV

One of the most useful functions that you can use to determine table structures is sys.dm_db_index_physical_stats. This DMV can provide insight into whether your table has a clustered index, how many nonclustered indexes exist, and whether your table (and each index) has row-overflow or Large Object (LOB) data. Most importantly, it can expose to you the entire ...

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