15.00 - Partitioned and Nonpartitioned Indexes and Tables - Teradata Database

Teradata Database Design

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

Partitioned and Nonpartitioned Indexes and Tables

A row‑partitioned index assigns rows to a particular partition within an AMP based on one or more user‑defined partitioning expressions. Only primary indexes can be row‑partitioned. Any index other than a partitioned primary index is, by default, an nonpartitioned index.

It is also possible to partition table and join index data using column partitions and no primary index. In this case, the table or join index can also optionally be row-partitioned. See “Column‑Partitioned Tables and Join Indexes” on page 285 for more information about column‑partitioned tables and join indexes.