15.00 - Minimizing Table Size - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Minimizing Table Size

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 single‑table join index, partitioned primary index, and column partitioning features to limit the portion of a table that must be scanned to access needed data.