I think I have solved the optimizer problem. It appears in samekeys().
Can someone check that function, and see if you come up with the same
fix I do (without knowing my fix)?
A 9-table join that used to run for minutes and fail now completes in
seconds! I want to commit this, but want confirmation from someone else
that my fix is correct.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026