How MySQL Optimizes DISTINCT?

  • DISTINCT is converted to a GROUP BY on all columns and it will be combined with ORDER BY clause.

  • Explanation:

     

How MySQL Optimizes DISTINCT?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges