Re: [GENERAL] Sequence scan if "OR Condition" in where statement

2012-05-11 Thread Albe Laurenz
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 -- Sent via pgsql-gen

[GENERAL] Sequence scan if "OR Condition" in where statement

2012-05-10 Thread Prashant Bharucha
Hello All Could you please help me , index is not using if have "OR condition in where statement" ? Always have sequence scan. Thanks Prashant