Re: [SQL] quest:optimization with indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] quest:optimization with indexes
Дата
Msg-id 9515.934410946@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [SQL] quest:optimization with indexes  (Clayton Cottingham <drfrog@smartt.com>)
Список pgsql-sql
Clayton Cottingham <drfrog@smartt.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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Clayton Cottingham
Дата:
Сообщение: Re: [SQL] quest:optimization with indexes
Следующее
От: Clayton Cottingham
Дата:
Сообщение: Re: [SQL] quest:optimization with indexes