Re: How to get around LIKE inefficiencies?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to get around LIKE inefficiencies?
Дата
Msg-id 1942.973480641@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to get around LIKE inefficiencies?  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: How to get around LIKE inefficiencies?  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
The Hermit Hacker <scrappy@hub.org> writes:
> On Mon, 6 Nov 2000, Philip Warner wrote:
>> At 21:59 5/11/00 -0500, Tom Lane wrote:
>>>> Looks like a great kluge to me ;-)
>> 
>> Hmph. I prefer to think of it as a 'user-defined optimizer hint'. ;-}

> Except, if we are telling it to get rid of using the index, may as well
> get rid of it altogether, as updates/inserts would be slowed down by
> having to update that too ...

Sure --- but do you have any other query types where the index *is*
useful?  If so, Philip's idea will let you suppress use of the index
for just this one kind of query.
        regards, tom lane


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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: How to get around LIKE inefficiencies?
Следующее
От: Philip Warner
Дата:
Сообщение: Re: How to get around LIKE inefficiencies?