From: | admin <admin(at)wtbwts(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | can't seem to use index |
Date: | 2000-01-09 21:33:31 |
Message-ID: | Pine.BSF.4.10.10001092128100.49372-100000@server.b0x.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Walker | 2000-01-09 23:02:20 | Re: [SQL] Serial field starting at 100 ? |
Previous Message | The Hermit Hacker | 2000-01-08 07:03:16 | Could this be done better...? |