Instead of trying to force WHERE clauses into CNF or DNF normal form,

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 9888192fb7732cdd1a85a7af9582d72a297d9a6d
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2003-12-30T21:49:19Z
Releases: 8.0.0
Instead of trying to force WHERE clauses into CNF or DNF normal form,
just look for common clauses that can be pulled out of ORs.  Per recent
discussion, extracting common clauses seems to be the only really useful
effect of normalization, and if we do it explicitly then we can avoid
cluttering the qual with partially-redundant duplicated expressions, which
was an unpleasant side-effect of the old approach.

Files

PathChange+/−
src/backend/optimizer/prep/prepqual.c modified +176 −522
src/backend/optimizer/README modified +4 −8