17.00 - 17.05 - No Primary Index (NoPI) Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

You can create tables without a primary index (NoPI). The performance of FastLoad and Teradata Parallel Data Pump (TPump) Array INSERT operations can be enhanced by using NoPI staging tables.

You can use NoPI tables as intermediate work tables where PI access is not a consideration. The system automatically balances the distribution of NoPI tables across AMPs.

NoPI tables are designed for these circumstances:

  • Temporary use
  • When you have not yet determined a suitable primary index
  • Column-partitioning (which cannot be done on tables with a primary index)

In all other circumstances, Teradata recommends that you specify a primary index when you create a table.