Re: [SQL] quest:optimization with indexes

From: Clayton Cottingham <drfrog(at)smartt(dot)com>
To:
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] quest:optimization with indexes
Date: 1999-08-11 17:43:30
Message-ID: 37B1B641.5AD0DC0C@smartt.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-08-11 22:35:46 Re: [SQL] quest:optimization with indexes
Previous Message Ross J. Reedstrom 1999-08-11 14:12:57 Re: [SQL] quest:optimization with indexes