Received: from dfw-ix8.ix.netcom.com (dfw-ix8.ix.netcom.com [206.214.98.8]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA36234 for ; Wed, 11 Aug 1999 13:36:50 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (from smap@localhost) by dfw-ix8.ix.netcom.com (8.8.4/8.8.4) id MAA10448 for ; Wed, 11 Aug 1999 12:36:10 -0500 (CDT) Received: from 00-10-4b-66-ed-f1.bconnected.net(209.53.23.202) by dfw-ix8.ix.netcom.com via smap (V1.3) id rma010277; Wed Aug 11 12:35:02 1999 Sender: DrFrog@ix.netcom.com Message-ID: <37B1B641.5AD0DC0C@smartt.com> Date: Wed, 11 Aug 1999 17:43:30 +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 CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] quest:optimization with indexes References: <37B0AAE0.926AE58D@smartt.com> <19990811091257.A2912@wallace.ece.rice.edu> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit thanks all, i actually was able to piece this all together last night! what i did was create another column that had a nextval sequence and im using that as an index, instead of over a thousand sec i am now getting a index with 2 sec thanks for all those 'like' tips i was wonderinng, would using regex be the same as far as the indexing rules go?