Posted by Thomas R. Hummel on 07/11/06 18:40

Erland Sommarskog wrote:
> Thomas R. Hummel (tom_hummel@hotmail.com) writes:
> > Thanks for the interesting solution Erland. In the real life case of
> > course, I will have many more columns than just my_id and line_number.
> > I realize that everything is dependent on the specific data, etc., but
> > in general, would you expect this to perform better than:
>
> I will have to admit not having done any benchmark on the two solutions.
> But my gut feeling is that the solution with MIN and GROUP BY generally
> is better. The other seems to give more chances for the optimizer to go
> astray.

I'll be sure to post some results here once I have both solutions in
place for testing. Might be a few days though.

-Tom.

[Back to original message]