16.10 - Volatility of Indexed and Partitioning Column Values - Teradata Database

Teradata Database Design

Teradata Database
Release Number
Release Date
June 2017
Content Type
User Guide
Publication ID
English (United States)

Primary indexes and row partitioning should be defined on columns that rarely, if ever, change. Changing the value of a primary index column or partitioning column almost certainly means that affected rows must be redistributed to different AMPs, which results in excessive I/O traffic on the BYNET and disk subsystems, or moved to a different partition on the same AMP.

This will minimize system-wide performance degradations caused by frequently changed primary index or partitioning column values.