RE: Anyway to optimize the optimizer

This is what I did (explained in my first message), the problem is Oracle does not substitute the value of C2 in the expression. Am I missing something?

Waleed

-----Original Message-----
From: jaromir nemec [mailto:jaromir_at_db-nemec.com]=20 Sent: Wednesday, March 02, 2005 7:40 PM
To: Khedr, Waleed; oracle-l_at_freelists.org Subject: Re: Anyway to optimize the optimizer

Hi Waleed,

I use in this case an additional predicate on partition key:

partition_key >=3D function(value_of_c2)

to cover the missing half of the pruning.

The function calculates the minimal possible value of the partition_key=20 based on the value of the c2 column (in this case: c2 - 10).

This solution is not very user friendly, but at least encapsulates the=20 "business logic" (subtract of 10) in the function.

Any more sophisticated solution will be highly appreciated,

Jaromir

• Original Message -----=20 From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> To: <oracle-l_at_freelists.org> Sent: Wednesday, March 02, 2005 6:23 PM Subject: Anyway to optimize the optimizer

I'm trying to achieve partition pruning when accessing a table using a column other than the partition key.

--
http://www.freelists.org/webpage/oracle-l