0

I have a general idea of what an indexed table looks like: first columns are indexed fields, last column is row id from the indexed table. But is there any way for me to actually view what a non-clustered indexed table looks like in SQL Server?

Sal
  • 1
  • You can use SQL Server Internals Viewer on Codeplex (available for 2008 and 2008 R2 but not 2012) but also best reading something like the SQL Server internals book to make sense of what it shows. – Martin Smith Dec 21 '13 at 11:18
  • Clustered and non-clustered indexes don't have a very different structure internally. They are almost exactly identical on-disk and regarding behavior. – usr Dec 21 '13 at 13:33

1 Answers1

0

Have a look here: http://use-the-index-luke.com/sql/anatomy

It explains the internal structure of B-tree indexes in general.

Markus Winand
  • 8,371
  • 1
  • 35
  • 44