MaxJoinTables - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

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 Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.
database limits Teradata Vantage™ - SQL Fundamentals, B035-1141.