Compute the number of clustered index pages

Formula

Example

(2016 / Clustered row size) - 2

=

No. of clustered index rows per page

(2016 / 9) - 2

=

222

No. of rows / No. of CI rows per page

=

No. of index pages at next level

750,000 / 222

=

3379

If the result for the “number of index pages at the next level” is greater than 1, repeat the following division step, using the quotient as the next dividend, until the quotient equals 1, which means that you have reached the root level of the index:

Formula

No. of index pages at last level

/

No. of clustered index rows per page

=

No. of index pages at next level

Example

3379 / 222

=

16 index pages (Level 1)

16 / 222

=

1 index page (Level 2)