| From: | Theo Kramer <theo(at)flame(dot)co(dot)za> |
|---|---|
| To: | hackers(at)postgresql(dot)org |
| Subject: | Index scan? |
| Date: | 1999-08-13 06:32:36 |
| Message-ID: | 37B3BC04.490D3187@flame.co.za |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
Does anyone know why the following occurs?
coza=> explain select * from accounts where domain >= '%' order by domain;
NOTICE: QUERY PLAN:
Index Scan using domain_idx on accounts (cost=1434.50 rows=19611 width=106)
and
coza=> explain select * from accounts order by domain;
NOTICE: QUERY PLAN:
Sort (cost=3068.39 rows=58830 width=106)
-> Seq Scan on accounts (cost=3068.39 rows=58830 width=106)
Surely both queries give the same result set, yet the second example does not
use the index causing unnecessary overhead.
I am running version 6.5 (haven't upgraded to 6.5.1 as yet)
--------
Regards
Theo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ansley, Michael | 1999-08-13 08:28:37 | Unlimited query strings |
| Previous Message | Tom Ivar Helbekkmo | 1999-08-13 06:22:56 | Re: [HACKERS] Re: We won! |