The row format diagrams and the examples in this section portray a system with 64 KB rows. A system with larger, 1 MB rows is not shown.
The following conditions affect the structure of base table rows:
- Whether the primary index of the table is partitioned.
- Whether the system uses byte-packed (packed64) format or 64-bit byte-aligned (aligned row) format.
Row format information is used to make fine-grained row size estimates for capacity planning.
- General Row Structure
- Sector Alignment
- General Row Structure When Compressing Variable Length Columns
- Row Structure for Packed64 Systems
- Packed64 Row Structure for a Partitioned Table
- Row Structure for Aligned Row Format Systems
- Aligned Row Structure for a Partitioned Table with 65,535 or Fewer Combined Partitions
- Containers and Space
- Container Contents
- Containers and Autocompression
- Row Structure for Containers (COLUMN Format)
- Container for the Delete Column Partition
- Row Structure for Subrows (ROW Format)
- Alignment of Containers and Subrows
- Column Partitioning
- Consumption of Disk Space by Populated and Empty Partitions
- Byte Alignment
- Row Length Characteristics and Row Components
- Example: Algorithmic Compression But No Multivalue Compression
- Example: Multivalue Compression But No Algorithmic Compression
- Example: Mix of Multivalue and Algorithmic Compression