MySQL Forums
Forum List  »  Partitioning

Re: Partition Pruning based on subquery / join result
Posted by: Justin Holdsworth
Date: July 13, 2010 09:33AM

Rick,

Thanks for having a look.

Turns out that partition pruning can only occur if the where clause directly relates to the partition key. In this case the optimiser can't / isn't collapsing the join down that way (as seen by Q1 referencing dd.date_id and Q2 referencing ff.date_id).

There's a bug open (has been for a fair while) on this :
http://bugs.mysql.com/bug.php?id=26630

Cheers
Justin

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partition Pruning based on subquery / join result
2153
July 13, 2010 09:33AM


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.