Sequence scan if "OR Condition" in where statement

Started by Prashant Bharuchaalmost 14 years ago2 messagesgeneral
Jump to latest
#1Prashant Bharucha
prashantbharucha@yahoo.ca

Hello All

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

Always have sequence scan.

Thanks
Prashant

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Prashant Bharucha (#1)
Re: Sequence scan if "OR Condition" in where statement

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