Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow Queries with OR's? - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Slow Queries with OR's?
Date
Msg-id 200304291516.09328.shridhar_daithankar@nospam.persistent.co.in
Whole thread Raw
In response to Slow Queries with OR's?  ("Mad Hatter" <mad_hatter_@hotmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Solaris
Next
From: Richard Huxton
Date:
Subject: Re: adding times togeather