Re: optimizer question

> "Reinoud van Leeuwen" <reinoud@xs4all.nl> writes:
> > I have a table that contains almost 8 milion rows. The primary key is a 
> > sequence, so the index should have a good distribution. Why does the 
> > optimizer refuse to use the index for getting the maximum value?
> 
> The optimizer has no idea that max() has anything to do with indexes.
> You could try something like
> 
>     select * from tab order by foo desc limit 1;

Can we consider doing this optimization automatically?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026