| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Partition Pruning
Tim
Is it also the casse even if I have local partitioned index on Mgrid. Is there any other way that I can put partition as clause in mine query to use the particular partitions atleast for some of mine report.
Thanks for your input
Sanjay
Tim Gorman <tim_at_sagelogix.com> wrote:
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_at_yahoo.com 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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed May 05 2004 - 08:14:49 CDT
 |
 |