Re: Understanding sequential versus index scans.

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Understanding sequential versus index scans.
Дата
Msg-id 4A63B0B7.4030109@hogranch.com
обсуждение исходный текст
Ответ на Understanding sequential versus index scans.  (Robert James <srobertjames@gmail.com>)
Список pgsql-general
Robert James wrote:
> Hi.  I notice that when I do a WHERE x, Postgres uses an index, and
> when I do WHERE y, it does so as well, but when I do WHERE x OR y, it
> doesn't.  Why is this so? And how can I shut this off?

maybe its because you have no index on (X OR Y) ?  or maybe because the
analyzer thinks that X or Y includes enough rows that a sequential scan
is more effective ?





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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Understanding sequential versus index scans.
Следующее
От: Dennis Gearon
Дата:
Сообщение: Re: timestamp with time zone tutorial