how come no one response to my email? thanks! My question is below:
Hi, I have some question on JOIN and INDEX usage on GROUP BY. Hope you can help me. thanks! 1. If there is any performance differenct for join from a small table to a big table and join from a big table to a small table? 2. If index on group by column order, will it have any query performance gain? 3. If having WHERE clause using exact order of the index column be faster than WHERE clause using only first column of the index (not exact order o the index column). Is there any web site have more detail of how mysql using index? thanks! HHT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
