You partitioned the MANAGER table by MGRID, not by EMPID. Oracle can't perform pruning unless your query is referencing the partition-key column. on 5/4/04 10:46 AM, Sanjay Mishra at smishra_97@xxxxxxxxx wrote: > 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 ---------------------------------------------------------------- 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 -----------------------------------------------------------------