Seq Scan

From: Linh Luong <linh(dot)luong(at)computalog(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Seq Scan
Date: 2001-05-28 16:24:41
Message-ID: 3B127BC9.683CD993@computalog.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

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?

Thanks again

--
Linh Luong
Computalog Ltd.
Software Developer
Phone: (780) 464-6686 (ext 325)
Email: linh(dot)luong(at)computalog(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kovacs Zoltan 2001-05-28 16:37:18 order after WHERE clause
Previous Message Vladislav Breus 2001-05-28 14:03:32 sql user management