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.
The 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.