17.10 - RevertJoinPlanning - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Determines whether the Teradata query Optimizer uses newer or older join planning techniques.

Field Group

Performance

Valid Settings

Setting Description
TRUE Causes the Teradata query Optimizer to use older join planning logic, and limits the maximum number of tables that can be used for join planning to 64.

To restrict all users to no more than 64 tables joined per query block, set RevertJoinPlanning in DBS Control to TRUE.

FALSE Causes the Teradata query Optimizer to use new join planning logic.

Default

FALSE

Changes Take Effect

After the DBS Control record has been written.

Related Information

For more information on… See…
the maximum number of tables that can be joined MaxJoinTables.
join planning and optimization Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.