Received: from web13804.mail.yahoo.com (web13804.mail.yahoo.com [216.136.175.14]) by postgresql.org (8.11.3/8.11.1) with SMTP id f593RTE82048 for ; Fri, 8 Jun 2001 23:27:29 -0400 (EDT) (envelope-from subra100@yahoo.com) Message-ID: <20010609032725.53194.qmail@web13804.mail.yahoo.com> Received: from [203.199.228.127] by web13804.mail.yahoo.com; Fri, 08 Jun 2001 20:27:25 PDT Date: Fri, 8 Jun 2001 20:27:25 -0700 (PDT) From: Subra Radhakrishnan Subject: Index usage To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200106/137 X-Sequence-Number: 3358 Hi All, The index created by me is not being used while doing select. I found that out by using the EXPLAIN. For example: Table department has ---------------- dept_num dept_desc Table 'employee' looks like this: -------------------------------- emp_num primary key, emp_name, dept_num (this is by way of foreign key relation from department table) Now, I create an index on the employee table using 'dept_num' as the attribute. And when I run select which looks like: Explain Select * from employee where dept_num = 'Finance'; It does not use the index and tells me that a Sequential scan will be done on the table employee. How do I fix this? Thanx in advance, Subra __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/