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

FAQ