346185
Lookup condition
- like a WHERE clause
- Data types must match
- must have
- multiple conditions
- evaluates as AND
- evaluates as AND
- Optimize order
- 1- equal =
- 2<,>,<=,>=
- 3 (not) !=
- 3 (not) !=
- 2<,>,<=,>=
- 1- equal =
- matches NULL values
- dynamic cache
- can only use = (equal)
- can only use = (equal)
- Handling Multiple Matches
- Use first or last value
- lookup cache order
- lookup cache order
- use any
- create index on keys
- create index on keys
- return ALL rows
- active
- cant switch
- cant switch
- active
- return an error
- static or no cache
- marks the row
- shows in session log
- increases error count
- increases error count
- shows in session log
- marks the row
- dynamic
- fails the session
- fails the session
- static or no cache
- Use first or last value
Want to create your own Mind Maps for free with GoConqr? Learn more.