MySQL Forums
Forum List  »  Partitioning

Re: EXPLAIN PLAN for partitions
Posted by: Mikael Ronström
Date: December 27, 2005 10:40AM

Partha Dutta wrote:
> I think the partitioning concept is really good,
> and it does seem to work, cutting down on the
> number of records that need to be scanned. What I
> would like to see is an incorporation of partition
> elimination in the EXPLAIN PLAN, to really see
> what exactly is happening under the hood. Any
> plans?

We are in the process of completing the partitioning optimisations and EXPLAIN support
will be there. It will be available by using EXPLAIN PARTITIONS. It will be part of the
next 5.1 release and is already available in the source tree for 5.1 if anyone wants to
play around with it.

Rgrds Mikael

> Edited 1 times. Last edit at 11/28/05 01:08PM by
> Partha Dutta.

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:

Options: ReplyQuote

Written By
November 28, 2005 12:08PM
November 29, 2005 06:43AM
November 30, 2005 03:23PM
Re: EXPLAIN PLAN for partitions
December 27, 2005 10:40AM

Sorry, you can't reply to this topic. It has been closed.

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.