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)