Re: GROUP BY vs DISTINCT - questions

| | cc: | | Fax to: | | Su

GROUP BY vs DISTINCT - questions

Hi, 1. What is the difference between GROUP BY and DISTINCT in the background engine? How MySQL treats each one of them? 2. Why GROUP BY statement ALWAYS uses a temporary file??? 3. Why using LIMIT with a GROUP BY statement takes about the same time as without using LIMIT? any answer would be