On 11:33 am 07/21/08 "A B" <gentosaker(at)gmail(dot)com> wrote:
> and I want it to be
> A 1
> B 3
> C 44
The slow way
select distinct field1, field2 from sometable.
The faster way
select field1,fields2 from sometable group by field1, field2.
Distinct should in theory be the same speed, but on several tests I have
done group by was faster. I posted a message to the list and there were
some explanations why group by was faster.. Hopefully someday they should
perform just as efficiently.