Re: Slow Queries with OR's?

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow Queries with OR's?
Date: 2003-04-29 09:46:09
Message-ID: 200304291516.09328.shridhar_daithankar@nospam.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-04-29 11:35:10 Re: adding times togeather
Previous Message Mad Hatter 2003-04-29 09:01:04 Slow Queries with OR's?