Maximize Performance with DB Lookups in a Decision Table

[former_member348835]

A decision table often contains multiple conditions. Some of the conditions may be DB Lookup expressions:

Condition 1	Condition 2 (DB Lookup)	Result

Question 1

If Condition 1 is false, will the DB Lookup in Condition 2 then be carried out?

If the answer is yes, how do you recommend preventing the DB lookup next to false conditions?

Question 2

If the DB Lookup is carried out in the first row, will the same DB Lookup be carried out in the next row?

If yes, how do you recommend preventing redundant lookups of the same value?

[carsten_ziegler · Accepted solution]

Question 1

Depending on the version of BRFplus (and notes) Condition 2 Lookup may be executed. This is done for optimization purposes and the behavior could also change in the future as we constantly optimize it.

Question 2

Once the expression defining the column is executed it will not be executed again.