can't seem to use index

Поиск
Список
Период
Сортировка
От admin
Тема can't seem to use index
Дата
Msg-id Pine.BSF.4.10.10001092128100.49372-100000@server.b0x.com
обсуждение исходный текст
Список pgsql-sql
I'm trying to use an index on a varchar(32) field, but explain keeps
retuning a sequential scan. This is my table and index:

CREATE TABLE manufacturer ( id int2, name varchar(32)
);

CREATE INDEX manu_name_idx ON "manufacturer" using btree ( "name"
"text_ops" );

Both my table and index have been created successfully, and the database
has been vacuumed. Then I run the following query from the psql
command-line:
explain select * from manufacturer where name='3COM';

... and I get a sequential scan! What gives?

Any suggestions would be greatly appreciated,
Marc



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

Предыдущее
От: "Richard Walker"
Дата:
Сообщение: Re: [SQL] Serial field starting at 100 ?
Следующее
От: "Albert Loo"
Дата:
Сообщение: query to do a backward 'skip', possible with (index) optimization ?