15.00 - Options for Storing a NoPI Table - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Options for Storing a NoPI Table

The following graphic shows four options for storing a NoPI table in Teradata Database, where the darkened row for each table represents a table header, one on 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 NoPI storage.

  • Traditional Teradata Database 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
  • The topics that follow compare various configurations of nonpartitioned NoPI and column‑partitioned tables.