Options for Storing a NoPI Table - Teradata Database

Teradata Database Design
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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 NoPI tables.