Filter
Top Products
Example 4:
Estimate of the required amount of space for a BTREE structure
Calculate the required amount of space when an index is added for the ORDER table having the
following kind of structure. PRICE and ORDERQTY is used as the secondary key for the index. The
ORDER table has a SEQUENTIAL structure, with a total of 30,000 records. The table structure is as
follows:
Storage structure:
BTREE structure with PRICE and ORDERQTY as a secondary key
Page size (data part):
16 kilobytes
Page size (index part):
2 kilobytes
Utilization rate (data part):
0.5
Utilization rate (index part):
0.5
Compression rate (data part):
0.3
Compression rate (index part):
0.5
164