Re: [SQL] quest:optimization with indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Clayton Cottingham <drfrog(at)smartt(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] quest:optimization with indexes
Date: 1999-08-11 22:35:46
Message-ID: 9515.934410946@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Clayton Cottingham <drfrog(at)smartt(dot)com> writes:
> thanks for all those 'like' tips i was wonderinng, would using regex be the
> same as far as the indexing rules go?

It's equivalent --- an index can help if the pattern is anchored to the
start of the string. Of course the pattern notation is different...

regards, tom lane

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Clayton Cottingham 1999-08-11 23:38:31 Re: [SQL] quest:optimization with indexes
Previous Message Clayton Cottingham 1999-08-11 17:43:30 Re: [SQL] quest:optimization with indexes