Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Anyway to optimize the optimizer

Re: Anyway to optimize the optimizer

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Thu, 3 Mar 2005 01:40:19 +0100
Message-ID: <039501c51f89$94686f60$3c02a8c0@JARAWIN>


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

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
Received on Wed Mar 02 2005 - 19:44:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US