![]() |
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)
20 Apr 2015
| 1 comment
,
|
![]() |
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
11 Jul 2011
| 2 comments
,
|