17.10 - Minimizing Table Size - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Design

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
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, Vantage 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.