From: | "michael" <miblogic(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2953: index scan, feature request |
Date: | 2007-02-01 12:00:25 |
Message-ID: | 200702011200.l11C0Ppm051827@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2953
Logged by: michael
Email address: miblogic(at)yahoo(dot)com
PostgreSQL version: 8.2.0
Operating system: windows 2000
Description: index scan, feature request
Details:
hi postgresql team,
can these be executed with index seek like what MS SQL does?
select * from account_category
where account_category_full_description <> 'MICHAEL'
this query resolves to sequential scan in postgres.
i saw ms sql, execution plan for the above query would become:
account_category_full_description < 'MICHAEL' or
account_category_full_description > 'MICHAEL'
thus it would utilize index scan
internally the above ms sql code would execute as:
select * from account_category
where account_category_full_description < 'MICHAEL'
or account_category_full_description > 'MICHAEL'
does my example warrant index scan?
thanks,
mike
From | Date | Subject | |
---|---|---|---|
Next Message | Sergiy Vyshnevetskiy | 2007-02-01 13:23:30 | Re: BUG #2948: default null values for not-null domains |
Previous Message | Peter Eisentraut | 2007-02-01 08:23:16 | Re: BUG #2948: default null values for not-null domains |