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

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.