The formulas and examples that follow show how to calculate the sizes of tables and indexes. This example uses the same columns sizes and index as the previous example. See “Tables and indexes used in the formulas” for the specifications.
The formulas for data-only-locked tables are divided into two sets of steps:
Steps 1–3 outline the calculations for a data-only-locked table. The example that follows Step 3 illustrates the computations on a table that has 9,000,000 rows.
Steps 4–8 outline the calculations for computing the space required by an index, followed by an example using the 9,000,000-row table.