Types of Conditions
•Conditions
on the workflow-related status of the events.
–E.g.,
“Open, Ready-to-ship orders”
–These
are ideal to reach rows requiring the next step in the workflow
process, once, but if we reach those rows more than once
following such a condition, the process is inefficient!
–Efficient
workflow implies these are recent rows!
–These usually require an index and a histogram, so
the optimizer “knows” the few-valued “status” column
is highly selective for the “open” statuses.