Max Tables in Join

Max Tables in Join is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Max Tables in Join property works together with the Max Tables in Join Warning property. It specifies the maximum number of tables in a join. If the maximum number of tables in a join (specified by the Max Tables In Join property) is exceeded, then the Max Tables in Join Warning property decides the course of action.

The table below explains the possible values and their behavior:

Value	Behavior
0	No limit on the number of tables in a join
Number	The maximum number of tables in a join is set to the number specified

Levels at Which You Can Set This

Database instance only