>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.
I don't have an idea, right now, how to make this faster. I was thinking about a composite index, but probably I was on the wrong track on this one.
(Still planning to leave in 5 minutes...)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)