You are here

EXPLAIN FORMAT=JSON provides insights on optimizer_switch effectiveness

MySQL Performance Blog - Mon, 28/12/2015 - 7:20pm

The previous post in the EXPLAIN FORMAT=JSON is Cool! series showed an example of the query [crayon-5681b0e640014827276115-i/], where the subquery was materialized into a temporary table and then joined with the outer query. This is known as a semi-join optimization. ...

The post EXPLAIN FORMAT=JSON provides insights on optimizer_switch effectiveness appeared first on MySQL Performance Blog.