Seq Scan - Mailing list pgsql-sql

From Linh Luong
Subject Seq Scan
Date
Msg-id 3B127BC9.683CD993@computalog.com
Whole thread Raw
Responses Re: Seq Scan
List 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.luong@computalog.com


pgsql-sql by date:

Previous
From: Martín Marqués
Date:
Subject: Re: Recursive select
Next
From: Kovacs Zoltan
Date:
Subject: order after WHERE clause