Example Measurement 2
This example examines the size of a simple join index created for the same tables used in “Example Measurement 1” on page 552. There is a savings of 8 bytes because there is no COUNT column and no SUM(INTEGER) column.
The computed row size is as follows:
The permanent space specification is as follows.
|
Current Permanent Space (Bytes) |
Peak Permanent Space (Bytes) |
Maximum Permanent Space (Bytes) |
|
1,561,216,000 |
1,561,216,000 |
0 |
Using these figures, you can compute a measured row size.
As with “Example Measurement 1” on page 552, the measured and computed disk spaces are identical, and you can conclude that the disk space formula is accurate for a simple join index.