Re: like performance w/o wildcards.

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: like performance w/o wildcards.
Дата
Msg-id 3F2E9323.3090405@selectacast.net
обсуждение исходный текст
Ответ на Re: like performance w/o wildcards.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: like performance w/o wildcards.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Bruce Momjian wrote:
> Well, I don't see that = would be significantly faster than LIKE with a
> no-wildcard string, so I don't see the value in having LIKE detect
> non-whildcard strings.
>
Because it won't use an index for a LIKE, only a seqscan.


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: like performance w/o wildcards.
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: like performance w/o wildcards.