Show How MySQL Treats the Query
Registered by
Volodymyr Kolesnykov
When the EXTENDED keyword is used, EXPLAIN produces extra information that can be viewed by issuing a SHOW WARNINGS statement following the EXPLAIN statement. This information displays how the optimizer qualifies table and column names in the SELECT statement, what the SELECT looks like after the application of rewriting and optimization rules, and possibly other notes about the optimization process.
This information might be useful to developers as it shows how MySQL treats their query and what else can be optimized.
Blueprint information
- Status:
- Complete
- Approver:
- None
- Priority:
- Undefined
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- Approved
- Series goal:
- Accepted for 0.6
- Implementation:
- Implemented
- Milestone target:
- 0.6.1
- Started by
- Volodymyr Kolesnykov
- Completed by
- Volodymyr Kolesnykov
Whiteboard
(?)