OSDN Git Service

Instead of trying to force WHERE clauses into CNF or DNF normal form,
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 30 Dec 2003 21:49:19 +0000 (21:49 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 30 Dec 2003 21:49:19 +0000 (21:49 +0000)
commit9888192fb7732cdd1a85a7af9582d72a297d9a6d
tree8e1967206cb9b33b2cc2e2a0c87deb8346123992
parent7af16b2a258cff21dd5b94d9e9cb2229fbde7fb1
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.
src/backend/optimizer/README
src/backend/optimizer/prep/prepqual.c