Re: Anyway to optimize the optimizer

Hi Waleed,

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

partition_key >= function(value_of_c2)

to cover the missing half of the pruning.

The function calculates the minimal possible value of the partition_key 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 "business logic" (subtract of 10) in the function.

Any more sophisticated solution will be highly appreciated,

Jaromir

• Original Message ----- 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