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

[31 May 2006 10:07] [ name withheld ]
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
[31 May 2006 21:30] Valeriy Kravchuk
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.
[4 Oct 2008 21:00] Konstantin Osipov
http://forge.mysql.com/worklog/task.php?id=2985 Partition pruning added EXPLAIN PARTITIONS

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.