Re: Sequence scan if "OR Condition" in where statement

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Prashant Bharucha *EXTERN*" <prashantbharucha(at)yahoo(dot)ca>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sequence scan if "OR Condition" in where statement
Date: 2012-05-11 08:53:25
Message-ID: D960CB61B694CF459DCFB4B0128514C207DECB73@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Prashant Bharucha wrote:
> Could you please help me , index is not using if have "OR condition in
where statement" ?
>
> Always have sequence scan.

You need to provide more details, see
http://wiki.postgresql.org/wiki/SlowQueryQuestions
to get an idea.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Evan Martin 2012-05-11 10:16:59 Why is RELEASE SAVEPOINT sometimes slow?
Previous Message Mike Christensen 2012-05-11 04:52:13 Re: Question about schema-level permissions