On Sun, 23 Jun 2002 17:16:09 EDT, the world broke into rejoicing as Bruce Momjian <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]