0 - 2 of 2 tags for optimisation

hello everyone.

 

i have an INSERT query with a subquery like this one:

 

SELECT 1

 

            FROM SD_CRM.D_INDIV_PREF DIP

 

            WHERE DIP.SITE = FPL.SITE

 

                AND  TRIM(DIP.ID_CLIENT) = TRIM(FPL.ID_CLIENT)

 

Is there any other way of reliably tell the optimizer to use the PPI other than hard-coding the minimal/maximal value (date) in a following case?

Here is a DDL for a big table with customer transactions:

transaction_table
PRIMARY INDEX NUPI_txn ( transaction_id )
PARTITION BY RANGE_N(transaction_date BETWEEN DATE '2008-01-01' AND DATE '2012-12-31' EACH INTERVAL '1' DAY , NO RANGE OR UNKNOWN)
INDEX NUSI_customer_id( customer_id)