Influences the maximum number of tables that can be joined per query block.
Field Group
Performance
Valid Settings
0, and 64 through 128
Zero means MaxJoinTables will use the system default upper limit of 128.
Default
0
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
MaxJoinTables sets a system-wide upper bound on the MaxJoinTables cost parameter used during optimization. The value 0 is mapped internally to 128.
If the RevertJoinPlanning DBS Control field is set to TRUE, the maximum join tables is 64, regardless of the MaxJoinTables setting.
Related Information
| For more information on… | See… |
|---|---|
| RevertJoinPlanning | RevertJoinPlanning. |
| join planning and optimization | SQL Request and Transaction Processing, B035-1142. |
| database limits | Teradata Vantage™ - SQL Fundamentals, B035-1141. |