Re: Partition Pruning

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 4 May 2004 15:14:07 -0400
Message-ID: <BAY9-DAV3tneqdGSyMp0000601f@hotmail.com>

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" <smishra_97_at_yahoo.com> To: <oracle-l_at_freelists.org>
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_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 Tue May 04 2004 - 14:14:43 CDT