You are here

EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY

MySQL Performance Blog - Tue, 29/12/2015 - 8:39pm

Another post in the EXPLAIN FORMAT=JSON is Cool! series! In this post, we’ll discuss how the EXPLAIN FORMAT=JSON provides optimization details for [crayon-5683026550870772518911-i/] and  [crayon-5683026550882438771706-i/] operations in conjunction with [crayon-568302655088e480902004-i/] and  [crayon-568302655089c478222391-i/].  [crayon-56830265508ab633748052-i/] can print details on how a subquery in [crayon-56830265508b8374547610-i/] is optimized: [crayon-56830265508c0989181837/] The ...

The post EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY appeared first on MySQL Performance Blog.