15.00 - Cases Where Positive Performance Effects Are Most Likely To Occur - Teradata Database

Teradata Database Design

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

Cases Where Positive Performance Effects Are Most Likely To Occur

The greatest improvement in the performance of querying column‑partitioned tables occurs when a request specifies a highly selective predicate on a column in a single‑column partition of a column‑partitioned table with hundreds or thousands of columns and only a small number of them are projected by the request.