15.00 - All-AMP Tactical Queries and Partitioned Tables - Teradata Database

Teradata Database Design

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

All‑AMP Tactical Queries and Partitioned Tables

The major benefit that can be realized for all-AMP tactical queries running against partitioned primary index tables is row partition elimination. Rather than scanning an entire table, it is possible to scan a smaller subset of rows if the query specifies the partitioning key value for the table.

Avoid adjusting the granularity of partitions more finely than is warranted by the majority of the queries that run against the table. For example, if users never access data with a granularity smaller than a monthly range, there is no additional performance advantage to be gained by defining partitions that have a smaller range than one month.

For all-AMP tactical queries, you should include the partitioning columns as a constraint in the WHERE clause of your queries. If a query joins partitioned tables that have identical partitioning, you can enhance join performance still further by including an additional equality constraint on the partitioning columns of the two tables.