January 9, 2016 | Sveta Smirnova ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing
January 5, 2016 | Sveta Smirnova grouping_operation, duplicates_removal: EXPLAIN FORMAT=JSON has all details about GROUP BY
December 29, 2015 | Sveta Smirnova EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY
December 28, 2015 | Sveta Smirnova EXPLAIN FORMAT=JSON provides insights on optimizer_switch effectiveness
December 22, 2015 | Sveta Smirnova EXPLAIN FORMAT=JSON: everything about attached_subqueries, optimized_away_subqueries, materialized_from_subquery
December 18, 2015 | Sveta Smirnova used_key_parts: EXPLAIN FORMAT=JSON provides insight into which part of multiple-column key is used
December 14, 2015 | Sveta Smirnova used_columns: EXPLAIN FORMAT=JSON tells when you should use covered indexes
December 10, 2015 | Sveta Smirnova rows_examined_per_scan, rows_produced_per_join: EXPLAIN FORMAT=JSON answers on question "What number of filtered rows mean?"
December 8, 2015 | Sveta Smirnova attached_condition: How EXPLAIN FORMAT=JSON can spell-check your queries
