15.00 - How the Optimizer Uses the WHERE and ON Clauses - Teradata Database

Teradata Database Design

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

How the Optimizer Uses the WHERE and ON Clauses

The Optimizer uses WHERE or ON clause predicates as the foundation on which to build its access and join plans. Many predicates, or search conditions as they are often called, invoke the selection of indexes or row partition elimination by the Optimizer if the appropriate indexes or row partitioning have been defined on the columns specified by the predicate condition.

Specify these conditions whenever possible because they promote optimal performance and are selected by the Optimizer whenever table statistics, environmental cost parameters, and other demographics suggest they would decrease response time.