Partition Pruning
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 4 May 2004 09:46:17 -0700 (PDT)
Hi
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
Tx
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
