What factors determine the space occupancy of an object at database level?
The space occupancy of an object (such as a table or index) at database level is mainly determined by the quantity of data. However, in the following cases, space occupancy may be very different despite a comparable dataset: Fragmentation due to data deletions or unfavorable PCTFREE/PCTUSED values (Note 821687) Use of different tablespace types (dictionary-managed vs. locally-managed) Use of different extent sizes (INITIAL, NEXT) Use of different index types (B* tree vs.
