Re: A fairly obvious optimization?

On Sun, 23 Jun 2002 17:16:09 EDT, the world broke into rejoicing as
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> said:
> FAQ updated in section 4.8: My queries are slow or don't make use of the
> indexes. Why?
>
> is returned. In fact, though MAX() and MIN() don't use indexes,
> it is possible to retrieve such values using an index with ORDER BY
> and LIMIT:
> <PRE>
> SELECT col
> FROM tab
> ORDER BY col
> LIMIT 1
> </PRE>

This sounds like the sort of thing that would be really nice to be able
to automate into the query optimizer...
--
(reverse (concatenate 'string "moc.enworbbc@" "sirhc"))
http://www3.sympatico.ca/cbbrowne/spreadsheets.html
"I decry the current tendency to seek patents on algorithms. There
are better ways to earn a living than to prevent other people from
making use of one's contributions to computer science."
-- D. E. Knuth