16.10 - Minimizing Table Size - Teradata Database

Teradata Database Design

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

Request performance is directly proportional to the size of the set of tables accessed. As table size increases, Teradata Database requires additional I/O operations to retrieve or update data.

For large tables that cannot be reduced in size, you can use the secondary index, single-table join index, primary index, primary AMP index, and partitioning features to limit the portion of a table that must be scanned to access needed data.