Once again it’s time for another EXPLAIN FORMAT=JSON is cool! post. This post will discuss how EXPLAIN FORMAT=JSON allows the nested_loop command to make the JOIN operation hierarchy transparent.
EXPLAIN command lists each table that participates in a
JOIN operation on a single row. This works perfectly for simple queries:
mysql> explain select * from […]Read more