Re: max() not using index

From: Ralph Graulich <maillist(at)shauny(dot)de>
To: Peter Gibbs <peter(at)emkel(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: max() not using index
Date: 2002-07-17 12:40:03
Message-ID: Pine.LNX.4.21.0207171439080.7918-100000@shauny.shauny.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Peter,

> > -> 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;

Thanks alot. That did the trick.

Kind regards
... Ralph ...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Gibbs 2002-07-17 12:40:27 Re: max() not using index
Previous Message Manfred Koizar 2002-07-17 12:37:14 Re: Using index with order desc