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.

As an Amazon Associate I earn from qualifying purchases.