Monday 22 May 2017

How MySQL Optimizes DISTINCT ?

DISTINCT is converted to a GROUP BY on all columns and it will be combined with ORDER BY clause.
SELECT DISTINCT t1.a FROM t1,t2 where t1.a=t2.a;

No comments:

Post a Comment

Advertisement

Advertisement