Remove Repeated Tables for Outer Joins

Remove Repeated Tables For Outer Joins 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 Remove Repeated Tables For Outer Joins property determines whether an optimization for outer join processing is enabled or disabled. You have the following options:

• Disable optimization to remove repeated tables in full outer join and left outer join passes: The optimization for outer join processing is disabled. This can cause outer joins to require additional processing time.
• Enable optimization to remove repeated tables in full outer join and left outer join passes (default): The optimization for outer join processing is enabled. This can provide better response time for outer join processing.

However, if you sort or rank report results and some of the values used for the sort or rank are identical, you may encounter different sort or rank orders depending on whether you disable or enable this optimization. To preserve current sorting or ranking orders on identical values, you may want to disable this optimization.

Levels at Which You Can Set This

Database instance, report, and template