I am trying to execute this query I wrote and it is not returning at a
reasonable time to the browser. I took the query and ran EXPLAIN on it
and it displayed that every JOIN I do it is doing a Seq Scan on it. I
have indexes on that table but it doesn't seem to use it.
Is there a way I can ensure that postgres will use my indexes?
pgsql-general by date
|Next:||From: Dave Cramer||Date: 2001-05-28 17:08:23|
|Subject: Re: Seq Scan|
|Previous:||From: Tom Lane||Date: 2001-05-28 16:20:00|
|Subject: Re: Simple SQL question, need help. |