I have worked with Vadim privately on the remaining OR clause index
issues, and I am done. Please start testing, everyone.
The only open item is whether MergeJoin will try to use a multi-index OR
clause in a join, but I doubt anyone uses such things. It would require
you to join a table as part of a join clause.
select *
from tab1, tab2
where tab1.col1=2 or tab1.col1 = tab2.col2
I am going to study the optimizer code, then figure out whether this
could ever be broken with the new index usage. I plan to complete this
in time for 6.4.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)