git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Improve planning of OR indexscan plans: for quals like

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

Tue, 5 Jun 2001 17:13:52 +0000 (17:13 +0000)

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

Tue, 5 Jun 2001 17:13:52 +0000 (17:13 +0000)

commit cdd230d62899455cc07ba1caf68387fb834d5bd2

tree c74a0a5342eb883c0265f7caf2993a93e1eff939 tree

parent 7c579fa12df0def35192e1e3cfc9ea7ab90bb0cb commit | diff

Improve planning of OR indexscan plans: for quals like
WHERE (a = 1 or a = 2) and b = 42
and an index on (a,b), include the clause b = 42 in the indexquals
generated for each arm of the OR clause. Essentially this is an index-
driven conversion from CNF to DNF. Implementation is a bit klugy, but
better than not exploiting the extra quals at all ...

src/backend/optimizer/path/allpaths.c diff | blob | blame | history

src/backend/optimizer/path/indxpath.c diff | blob | blame | history

src/backend/optimizer/path/orindxpath.c diff | blob | blame | history

src/include/optimizer/paths.h diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom