Aligned Row Structure for a Partitioned Table with 65,535 or Fewer Combined Partitions - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The following graphic shows the basic structure of a database row from a table on an aligned row format system with a partitioned primary index that has 65,535 or fewer combined partitions:


""

The difference between this format and the format of an nonpartitioned table row is the presence of a 2-byte or 8-byte partition number field, which is also a component of the RowID. (Partitioned table rows are an additional 4 bytes wider with multivalue compression.) This field generates the need for a BYTE(10) data type specification for a RowID. For nonpartitioned primary index tables, the partition number is assumed to be 0, so the rowID of an nonpartitioned primary index table is also logically BYTE(10) (see ROWID Columns).