Purpose
Determines whether the Teradata Database query Optimizer uses newer or older join planning techniques.
Field Group
Performance
Valid Settings
| Setting | Description |
|---|---|
| TRUE | Causes the Teradata Database 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 Database query Optimizer to use new join planning logic. |
Default
FALSE
Changes Take Effect
After the DBS Control record has been written.
Related Topics
| 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. |