| From: | "John Oakes" <john(at)networkproductions(dot)net> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Index doesn't appear to be working. |
| Date: | 2002-03-03 00:28:23 |
| Message-ID: | 001801c1c24a$56369270$cb842341@john |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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? This query returns about 5,600 of 10,000
records. It is faster to just do a seq scan because it returns such a high
percentage or records? Thanks, I appreciate the help!
John Oakes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masaru Sugawara | 2002-03-03 06:00:01 | Re: using LIMIT only on primary table |
| Previous Message | Dan Langille | 2002-03-02 23:40:19 | Re: using LIMIT only on primary table |