Bruno, Tom,
> Typo. I meant to say columns. The issue is that max doesn't use an index,
> but if there are a lot of different values of G for a given A, B and C,
> it may be better to use an index then to search through the applicable
> rows to find the maximum.
That's odd ... you're correct. Tom, why doesn't MAX() use an index? I
understand why indexes are generally useless for SUM(), AVG, and COUNT, but
it seems that MAX() and MIN() should *always* use an index.
--
-Josh Berkus
Aglio Database Solutions
San Francisco