Directly optimizable predicates

Some predicates provide clear-cut starting and stopping points. A predicate provides start or stop conditions, and is therefore optimizable, when:
Related concepts
Indirectly optimizable predicates
Joins