Received: from mail.computalog.com ([209.82.103.230]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4SGHfA25843 for ; Mon, 28 May 2001 12:17:41 -0400 (EDT) (envelope-from linh.luong@computalog.com) Received: from jamie.edmonton.computalog.com (mugeri.computalog.com [209.82.103.229]) by mail.computalog.com (8.8.8/8.8.8) with ESMTP id KAA09511 for ; Mon, 28 May 2001 10:17:53 -0600 Received: from computalog.com (localhost [127.0.0.1]) by jamie.edmonton.computalog.com (Postfix) with ESMTP id 0B9AB197399 for ; Mon, 28 May 2001 10:24:41 -0600 (MDT) Message-ID: <3B127BC9.683CD993@computalog.com> Date: Mon, 28 May 2001 10:24:41 -0600 From: Linh Luong X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-pentiumiii-smp i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Seq Scan Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/299 X-Sequence-Number: 3140 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