You are here

EXPLAIN FORMAT=JSON: everything about attached_subqueries, optimized_away_subqueries, materialized_from_subquery

MySQL Performance Blog - Tue, 22/12/2015 - 10:41pm

EXPLAIN FORMAT=JSON The regular [crayon-5679f2185b3f7786726815-i/] command already provides some information about subquery optimization. For example, you can find out if the subquery is dependent or not, and (since version 5.6) if it was materialized: [crayon-5679f2185b407730830883/] However, ...

The post EXPLAIN FORMAT=JSON: everything about attached_subqueries, optimized_away_subqueries, materialized_from_subquery appeared first on MySQL Performance Blog.