MySQL EXPLAIN Visualization with mktools-visual-explain
March 13, 2008 1 Comment
EXPLAIN statement visualization is something I love about Aqua Data Studio (we use it a lot with DB2) and SQL Server Management Studio. It takes the result of your EXPLAIN and displays it in an easier to understand diagram. Here’s example output from SQL Server:
Aqua Data Studio doesn’t support MySQL Visual Explains (yet). The only way I’ve been able to find EXPLAIN visualization is with maatkit and mk-visual-explain.
Here’s an explain from one of the queries in a project (columns have changed names)
Here’s the output with mk-visual-explain
Which one is easier to understand?
bofe.org got taken over by russian spam bots 😦