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) |