Re: Query not using the indexes properly.

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Query not using the indexes properly.
Дата
Msg-id 855e4dcf0910011921g31084dcfkfa199d844b694f2@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query not using the indexes properly.  (David Wilson <david.t.wilson@gmail.com>)
Ответы Re: Query not using the indexes properly.  (David Wilson <david.t.wilson@gmail.com>)
Список pgsql-general
>
> If you try the multi-column index (which is a good idea), be sure that "id"
> is the last of the three columns, since that's the column on which you have
> an inequality test rather than an equality test; eg,
> (company_id,source_model_name,id).
>


Interesting. I would have thought the order of the fields would not
matter. I don't have to rewrite the query do I?

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

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Re: Query not using the indexes properly.
Следующее
От: David Wilson
Дата:
Сообщение: Re: Query not using the indexes properly.