Index doesn't appear to be working.

Поиск
Список
Период
Сортировка
От John Oakes
Тема Index doesn't appear to be working.
Дата
Msg-id NHRf8.10874$TV4.1590523@typhoon.tampabay.rr.com
обсуждение исходный текст
Список pgsql-general
I have a table with a column titled 'passfail' that only contains either a P
for pass or an F for fail.  The table name is 'one'.  I created the index on
the table with:

CREATE INDEX one_passfail_idx ON one USING btree (passfail);

I then do:

VACUUM ANALYZE one;

Then I do an explain on this query:

SELECT * FROM one where passfail = 'P';

and it tells me:

Seq Scan on one (cost=0.00..263.02 rows=5613 width=56)

Shouldn't it tell me

Index Scan using one_passfail_idx on one?

Why isn't it using the index?  Thanks, I appreciate the help!

John Oakes









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

Предыдущее
От: "Cornelia Boenigk"
Дата:
Сообщение: Question to CREATE FUNCTION
Следующее
От: "Randy Widell"
Дата:
Сообщение: Running under Cygwin...