Filter
Top Products
Example 2:
Estimate of the required amount of space for a RANDOM structure
Calculate the required amount of space for the ORDER table (total number of records: 30,000) having
this kind of structure:
The storage structure is designed as follows. The cluster key is the PRIMARY KEY (a unique constraint
is set). Thus, the formulas for a RANDOM structure (when a unique constraint is set for the cluster key)
are used.
Storage structure:
RANDOM structure with CUSTOMER and PRODNO as the cluster key
Page size:
4 kilobytes for both the prime part and the overflow part
Prime part utilization rate:
0.5
Overflow part utilization rate:
0.2
Overflow rate:
0.2
Safety factor:
1.3
162