Sequence scan if "OR Condition" in where statement

From: Prashant Bharucha <prashantbharucha(at)yahoo(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Sequence scan if "OR Condition" in where statement
Date: 2012-05-10 19:12:19
Message-ID: 1336677139.3156.YahooMailClassic@web125705.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All

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

Always have sequence scan.

Thanks
Prashant

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2012-05-10 19:16:53 Re: Multiple COPY statements
Previous Message Tom Lane 2012-05-10 19:08:27 Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE