On Tue, Apr 29, 2003 at 10:01:04AM +0100, Mad Hatter wrote:
> Why does using IN (or OR) give such a performance hit?
Because the implementation was not perfect ;-)
I gather there is a fix for this in CVS tip, so you might want to
give that a whirl to see if it solves your problem. (But don't use
it for real systems yet!)
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110