> When I group by the primary key, GROUP BY do not use the index.
>
> And the query takes an extremely long time!
>
> I really think there are some problems with GROUP BY and DISTINCT
> guys.
>

group by the PK? what on earth does that do? the PK is unique why would you
want to group by the PK?
Alan