Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Partition Pruning
Mike
I also have Local partitioned index on mgrid and I need to change the query to use partition instead of scanning all 100 partitions which is reallly very slow
Thanks
sanjay
Michael McMullen <ganstadba_at_hotmail.com> wrote:
Why would you expect it to partition prune on on the manager table? It's
partitioned on mgrid not empid and your join is where a.empid = b.empid.
Mike
ganstadba_at_hotmail.com
----- Original Message -----
From: "Sanjay Mishra"
To:
Sent: Tuesday, May 04, 2004 12:46 PM
Subject: Partition Pruning
> 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
-- 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:12:23 CDT