Lookup condition - created from Mind Map

like a WHERE clause

Data types must match

must have

multiple conditionsevaluates as AND

Optimize order 1- equal = 2,= 3 (not) !=

matches NULL values

dynamic cachecan only use = (equal)

Handling Multiple Matches Use first or last value use any return ALL rows return an error lookup cache order create index on keys active cant switch static or no cache dynamic marks the row shows in session log increases error count fails the session

Lookup condition