Strategy ONE

Lookup Table Join Order

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

This property determines how lookup tables are loaded for being joined. The setting options are

  • Partially based on attribute level (behavior prior to version 8.0.1) (default)
  • Fully based on attribute level. Lookup tables for lower level attributes are joined before those for higher level attributes

If you select the first option, lookup tables are loaded for join in alphabetic order.

If you select the second option, lookup tables are loaded for join based on attribute levels, and joining is performed on the lowest level attribute first.

Levels at Which You Can Set This

Report, template, and project