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 | SQL Request and Transaction Processing, B035-1142. |