D
David W. Fenton
Were you the one who said that life is too short??
The test demonstrated exactly what he had forecast, that DISTINCT is
the logical way to get DISTINCT values, and that GROUP BY is for a
different purpose (and would thus very likely not be as fast).
He only did the test because you stop you from continuing to natter
on about it.