The figure shows how an IOT (index-organized table) storage table for a nested table works when the
COMPRESS clause is used.
The storage table has two columns:
NESTED_TABLE_ID and Values.
NESTED_TABLE_ID column identifies the rows in the parent table to which the nested table's rows belong. In an IOT storage table, the parent row IDs are grouped together instead of being dispersed throughout the storage table. The figure shows storage groups for nested tables A, B, C, D, and E.
Additionally, when the
COMPRESS clause is used, only one parent row ID is stored for the entire group of rows that have that ID, saving space.