Packed64 Row Structure for a Partitioned Table - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

The following graphic shows the basic structure of a database row from a table on a packed64 format system with a partitioned primary index:


Packed64 row structure for partitioned table

The difference between this format and the format of a nonpartitioned primary index row is the presence of a an additional 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).