MySQL Forums
Forum List  »  Partitioning

Re: EXPLAIN PLAN for partitions
Posted by: Mikael Ronström
Date: November 30, 2005 03:23PM


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?

Well the result of the partition pruning is essentially three variables,
start partition, end partition and a bitmap to specify which partitions in
the range to use. This sounds fairly doable to get into the EXPLAIN.
I'll look into it and see if it is doable for 5.1.

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
Re: EXPLAIN PLAN for partitions
November 30, 2005 03:23PM
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.