Re: max() not using index

"Ralph Graulich" wrote:


> EXPLAIN SELECT MAX(dam_id) FROM dam;
> NOTICE:  QUERY PLAN:
>
> Aggregate  (cost=5774.65..5774.65 rows=1 width=4)
>   ->  Seq Scan on dam  (cost=0.00..5442.92 rows=132692 width=4)

select dam_id from dam order by dam_id desc limit 1;

--
Peter Gibbs
EmKel Systems