You're right, the Group By is making it drag anyway. Hmm...

>It seems to me that, because of the GROUP BY, all records have to be processed anyway. Try to omit min() and max(), and see whether the query gets much faster. I guess it won't, but I am curious whether I am guessing wrong in this case.
>
>(I am leaving in 5 minutes, so I will continue this discussion tomorrow - ca. 11:00 UTC.)
>
>Hilmar.