On Wed, Mar 2, 2011 at 11:31 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
> Don't know why it uses Seq Scan on loc_context_terror as i have indexes on
> the desired columns as well.
I don't see how an index scan would help. The query appears to need
all the rows from that table.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company