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 appriciated...
-thanks, Lorderon.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to