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

Sequence scan if "OR Condition" in where statement

From

Prashant Bharucha

Date:

10 May 2012, 16:12:36

Hello All

Could you please help me , index is not using if have "OR condition in where statement" ?

Always have sequence scan.

Thanks
Prashant

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

From

"Albe Laurenz"

Date:

11 May 2012, 05:54:49

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