You can see that the index has two levels only, the leaf level and the root page. The root page has 621 rows that point to 621 leaf pages. There is no internal fragmentation in this case.
- 15. Implementing Indexes and Statistics
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Based on their being index level 0 and index level 1.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/72736/