The following graphic shows four options for storing a table in an AMP, where the darkened row for each table represents a table header, one on data for each AMP, for a physical table. The table header defines the layout and other information about the physical table.
Moving from left to right, the structures represent the layouts of four different methods of storage.
- Traditional row storage without partitioning
- A column-partitioned table with single-column containers (COLUMN format), one for each column
- A column-partitioned table with single-column containers for columns A and B; multicolumn subrows (ROW format) for columns C and D
- A column-partitioned table with single-column containers for columns A and B; multicolumn containers for columns C and D