From: | "Staff, Alexander" <alexander(dot)staff(at)sap(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Index Usage Question |
Date: | 2003-10-24 14:18:02 |
Message-ID: | F3C17DB1905CD311BC400008C75F40CE0CF095FE@dewdfx26.wdf.sap.corp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I created a simple table (name char200, zip char10, city char200, street char200, id int) and filled some data, appr. 250 000 records, in it.
I tested accessing some rows (select id from address where id = 44444;, select * from address where id between 33333, 333444) with an unique index on id and without an index. EXPLAIN tells me in both cases that it does NOT use the index.
I tested this with using the name column (select name from address where name like 'Wal%';, select name from address where name = 'Walz') and if I created an index on name it uses it.
Using id in the where clause of the select is as slow as using an unindexed name in the where-clause.
I ran ANALYZE, no changes.
What's this ?
This is not a feature, is it ?
Thanks for any hints or explanations
Ciao
Alexander
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Gearon | 2003-10-24 14:18:35 | Re: About TSearch2 Performance |
Previous Message | Manfred Koizar | 2003-10-24 13:34:25 | Re: Nullable 'Foreign Key-like' Constraint |