Re: Partition Pruning

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 04 May 2004 11:52:31 -0600
Message-ID: <BCBD347F.1451B%tim@sagelogix.com>

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

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 - 12:51:05 CDT