Re: why does explain tell me I'm using a seq scan?

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: why does explain tell me I'm using a seq scan?
Дата
Msg-id 1068250763.61532.6.camel@jester
обсуждение исходный текст
Ответ на why does explain tell me I'm using a seq scan?  (Mark Harrison <mh@pixar.com>)
Список pgsql-general
On Fri, 2003-11-07 at 19:11, Mark Harrison wrote:
> I have indexed two columns in a table.  Can somebody explain to me why
> the first query below uses an Index Scan while the second uses a Seq
> Scan?

The first expects to find a single row, the second expects to find 17000
rows, a significant portion of the table where an index scan would be a
loss based on current tuning parameters.

--
Rod Taylor <pg [at] rbt [dot] ca>

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


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

Предыдущее
От: Mark Harrison
Дата:
Сообщение: why does explain tell me I'm using a seq scan?
Следующее
От: Adam Ruth
Дата:
Сообщение: Re: why does explain tell me I'm using a seq scan?