Received: from dfw-ix12.ix.netcom.com (dfw-ix12.ix.netcom.com [206.214.98.12]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA55305 for ; Tue, 10 Aug 1999 18:35:41 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (from smap@localhost) by dfw-ix12.ix.netcom.com (8.8.4/8.8.4) id RAA27419 for ; Tue, 10 Aug 1999 17:34:55 -0500 (CDT) Received: from 00-10-4b-66-ed-f1.bconnected.net(209.53.23.202) by dfw-ix12.ix.netcom.com via smap (V1.3) id rma027357; Tue Aug 10 17:34:14 1999 Sender: DrFrog@ix.netcom.com Message-ID: <37B0AAE0.926AE58D@smartt.com> Date: Tue, 10 Aug 1999 22:42:40 +0000 From: Clayton Cottingham X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.3.2 i586) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: quest:optimization with indexes Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hello, im looking for info/help on creating indexes im using 6.5 we have a table overe 100,000 rows if we put in an index or not an explain say it still does a seq scan, same amount of time taken! ive tried putting the index using just the oid , a combo of some fields of our data using btree where/what rules should be followed for setting up a good indexing scheme under pg?