MySQL Forums
Forum List  »  Partitioning

Re: Partition pruning - how much optimization is smart?
Posted by: Mattias Jonsson
Date: May 09, 2010 01:28PM

You can use 'EXPLAIN PARTITIONS' before your SELECT query and see the resulting column 'partitions' to see which partitions are left after pruning.

The code that handles the pruning is prune_partitions() in sql/opt_range.cc.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partition pruning - how much optimization is smart?
1512
May 09, 2010 01:28PM


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.