Step 4: Calculate the Number of Clustered Index Pages

After you have calculated the row size of the clustered index, you can calculate the number of pages for the clustered index.

(2016 / Clustered index row size) - 2 = Number of clustered index rows per page

(Number of data pages) / (Number of clustered index rows per page) = Number of index pages at level 0

If the result is greater than 1, repeat the following division step, using the quotient as the next dividend, until the quotient equals 1. When the quotient equals 1, you have reached the root level of the index.

(Number of index pages at the last level) / (Number of clustered index rows per page) = Number of index pages at next level