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

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

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.