Bug #77236 Automatic EXPLAIN suggestions
Submitted: 3 Jun 2015 19:50 Modified: 2 Sep 2015 6:33
Reporter: Philip Olson Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:6.3.3, 6.3.4 OS:Any
Assigned to: CPU Architecture:Any
Tags: feature request

[3 Jun 2015 19:50] Philip Olson 
Description:
The result view includes an "Execution Plan" tab with EXPLAIN data, and this is great. However, consider a preference titled "Automatically make suggestions based on EXPLAIN" (or similar) that'd automatically point out things like:

"Hey, you used a WHERE clause but the JOIN type was ALL. Not good. Check the Execution plan for additional information. Maybe column foo deserves an index?"

Obviously just a poor example, but promoting the use of indexes and EXPLAIN feels like a good idea. It would output this near the SQL editor textarea and not require opening the "Execution Plan" tab. I can't think an obvious way to display this, though. Maybe either highlight the "Execution Plan" tab button red and have the info there, or expand the Result Grid area with the info.

How to repeat:
Execute a query, and wonder how it can be improved.

Suggested fix:
Remind us that our query could be improved, and how we might go about improving it.
[2 Sep 2015 6:33] MySQL Verification Team 
Hello Philip Olson,

Thank you for the reasonable feature request!

Thanks,
Umesh