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]