On Tuesday 29 April 2003 14:31, Mad Hatter wrote:
> Why does using IN (or OR) give such a performance hit?
> Is there any way I can resolve this, it seem odd to be forced to UNION
> everything, and may not always be practicle to do so. It certianly makes
> the query text much longer!
Try exists instead on in. It is known to be faster..
HTH
Shridhar