Partition Pruning


I had a table emp that is range partitioned on
empid,dtjoin . It has another column created

and another table manager which is also range
partitioned on mgrid,dtpromotion

I am running query

select ....
from emp a , manager b
where a.empid=b.empid
and a.created > sysdate -1 and a.created < sysdate -0

Now the plan is using the Partition on emp table but
doing FTS of manager which has approx 100 partitions


Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs 
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: