Step 8: Calculate the number of leaf pages in the index  Step 10: Calculate the number of non-leaf pages

Chapter 16: Determining Sizes of Tables and Indexes

Step 9: Calculate the size of the non-leaf rows

Formula

Example

Size of leaf index row

        36

+

   4

Overhead

+

          4

= Size of non-leaf row

        40



Copyright © 2002. Sybase Inc. All rights reserved. Step 10: Calculate the number of non-leaf pages

View this book as PDF