On Wed, Mar 2, 2011 at 11:31 PM, Adarsh Sharma <adarsh.sha...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
