Re: Lack of use of indexes

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Lack of use of indexes
Дата
Msg-id Pine.LNX.4.33.0211220930520.25220-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Lack of use of indexes  (Don Isgitt <djisgitt@soundenergy.com>)
Список pgsql-general
On Fri, 22 Nov 2002, Don Isgitt wrote:

> Thanks, Doug for your very prompt reply. This newsgroup is wonderful.
>
> It will take a while, but I will create the table with text fields to
> see if that helps. The query with ...section='14' did not use the index.

Note that you can also "cast" the field you're searching on...

select * from sometable where field='14'::char(5)




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

Предыдущее
От: "Jan Weerts"
Дата:
Сообщение: Re: help in starting up / shutting down postgres as another user
Следующее
От: Tom Lane
Дата:
Сообщение: Re: improving a badly optimized query