MySQL Bugs: #20163: Explain plan - show partition usage

Bug #20163	Explain plan - show partition usage
Submitted:	31 May 2006 10:07	Modified:	4 Oct 2008 21:00
Reporter:	[ name withheld ] (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.1.x	OS:	Any (Any)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Please update the explain capabilities to include infos about the partitions accessed.
There is no point in having a standard EXPLAIN SELECT ... and a specific EXPLAIN  PARTITIONS ...
Thanks in advance

How to repeat:
Please update the explain capabilities to include infos about the partitions accessed.
There is no point in having a standard EXPLAIN SELECT ... and a specific EXPLAIN  PARTITIONS ...
Thanks in advance

Thank you for a reasonable feature request. I agree that having simple EXPLAIN [EXTENDED] that shows information about partitions usage in access path will be useful.

http://forge.mysql.com/worklog/task.php?id=2985 Partition pruning added EXPLAIN PARTITIONS