Why idex scan not used?
Why idex scan not used?
От:
"Andrei N.Sobchuck" <andrei@mart.cherkassy.ua>
Дата:
=> create table t(id int4 primary key); => explain select min(id) from t; NOTICE: QUERY PLAN: Aggregate (cost=43.00 rows=1000 width=4) -> Seq Scan on t (cost=43.00 rows=1000 width=4) EXPLAIN Is it possible to make postgresql to use index scan when it calculate MIN(id).
Re: [ADMIN] Why idex scan not used?
От:
Peter Eisentraut <e99re41@DoCS.UU.SE>
Дата:
On Tue, 29 Feb 2000, Andrei N.Sobchuck wrote: > Is it possible to make postgresql to use index scan when it calculate > MIN(id). Not currently, but it's on the todo list. -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden