Re: Partition Pruning based on subquery / join result
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 (...)
^^
Subject
Views
Written By
Posted
5259
July 09, 2010 03:54AM
2196
July 11, 2010 11:30AM
2293
July 12, 2010 05:05AM
Re: Partition Pruning based on subquery / join result
2300
July 12, 2010 11:41PM
2106
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.