MySQL Forums
Forum List  »  Partitioning

Re: Partition Pruning based on subquery / join result
Posted by: Rick James
Date: July 12, 2010 11:41PM

I don't know enough about the innards of PARTITION to give a definite answer. Note how the two queries start with different tables. Possibly "pruning" can only happen for the first table in a JOIN.

It is smart enough to realize that these are identical:
ON ff.date_id = dd.date_id WHERE dd.date_id IN (...)
ON ff.date_id = dd.date_id WHERE ff.date_id IN (...)
                                 ^^

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partition Pruning based on subquery / join result
2346
July 12, 2010 11:41PM


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.