O'Reilly logo
  • Dustin Waybright thinks this is interesting:

index_type_desc index_depth index_level page_count record_count avg_pg_spc_used_in_pct
--------------- ----------- ----------- ---------- ------------ ----------------------
CLUSTERED INDEX 3           0           622        18631        98.0435507783543
CLUSTERED INDEX 3           1           2          622          49.9258710155671
CLUSTERED INDEX 3           2           1          2            0.296515937731653

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

This is an inverse tree. The root page is on the bottom, with 2 records referring the the 2 intermediate pages. The first intermediate page refers to the 622 pages in the second intermediate page which then refers to all of the leaves.