How to pick indexes for order by and group by queries

(Dathan) Now some details that are usually missed. GROUP BY does sorting unless you tell mysql not to. GROUP BY has two optimization methods, loose index scan, and tight index scan.

Read More - Register for Free Membership