Hi,
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:
http://mikaelronstrom.blogspot.com