Re: Partition Pruning based on subquery / join result
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
Subject
Views
Written By
Posted
5471
July 09, 2010 03:54AM
2306
July 11, 2010 11:30AM
2417
July 12, 2010 05:05AM
2409
July 12, 2010 11:41PM
Re: Partition Pruning based on subquery / join result
2220
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.