Re: [GENERAL] Yet Another newbie not understanding why an index isn't used

Поиск
Список
Период
Сортировка
От Michal Maru¹ka
Тема Re: [GENERAL] Yet Another newbie not understanding why an index isn't used
Дата
Msg-id 199907050231.EAA09411@linux3.maruska.tin.it
обсуждение исходный текст
Ответ на Yet Another newbie not understanding why an index isn't used  (Felix Morley Finch <felix@crowfix.com>)
Список pgsql-general
> hlt=> EXPLAIN SELECT * FROM hltdata ORDER BY stmp, id LIMIT 10;


If I remember well, the order of the index attributes must be the same as
... in the query which should use it: try "id, stmp"


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