Predicate pushdown: filter before you join

Predicate pushdown in a query optimizer: split the WHERE into CNF clauses and push selections and projections below joins without changing the answer.

Part of Query optimization.

Read first

Read next