Re: Partition Pruning
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 5 May 2004 06:14:20 -0700 (PDT)
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@xxxxxxxxxxx> 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@xxxxxxxxxxx
----- 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
----------------------------------------------------------------
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
-----------------------------------------------------------------
---------------------------------
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@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:
