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.