Oracle Database Discussions

Hello,

I would like to update a partitionned table PS_GP_RSTL_ACUM with the next query, but the update tyime is without end.
If on another database, I uptade the same table without partition, the same query ended in 10 minutes.
Why ? And how to optimize my update on this partitionned table PS_GP_RSTL_ACUM ?
Thank you in advance for your help.
Nicolas.


Update :
UPDATE PS_GP_RSLT_ACUM A
SET USER_KEY1 = (
SELECT DISTINCT CHR_PIN_VAL
FROM PS_GP_RSLT_PIN B
WHERE B.PIN_NUM =
(
SELECT Z.PIN_NUM
FROM PS_GPFR_ILL_ROWPIN Z
WHERE Z.GPFR_ROW_NUM = 0
AND Z.GPFR_ILL_ROW_ID ='50'
)
AND B.EMPLID=A.EMPLID
AND B.EMPL_RCD=A.EMPL_RCD
AND B.CAL_RUN_ID=A.CAL_RUN_ID
AND B.GP_PAYGROUP=A.GP_PAYGROUP
AND B.RSLT_SEG_NUM=A.RSLT_SEG_NUM
AND B.ORIG_CAL_RUN_ID=A.ORIG_CAL_RUN_ID
)
WHERE exists (select 1 from ps_gp_pin c where c.pin_nm in (
'PRO AC JTL A',
'PRO AC JTLCF',
'PRO AC JTLCS',
'PRO AC JT ACQ',
'PRO AC JT ACQF',
'PRO AC JT ACQS',
'PRO AC CP ACQ',
'PRO AC CP ACQF',
'PRO AC CP ACQS',
'PRO AC CP ANT',
'PRO AC CP ANTF',
'PRO AC CP ANTS',
'PRO AC CT ACQ',
'PRO AC CT ACQS',
'PRO AC CT ACQF',
'PRO AC RCCEA ACQ',
'PRO AC RCCEA ACQS' ,
'PRO AC RCCEA ACQF',
'PRO AC RCL ACQ',
'PRO AC RCL ACQS',
'PRO AC RCL ACQF',
'PRO AC RCR ACQ',
'PRO AC RCR ACQS',
'PRO AC RCR ACQF',
'PRO AC BM ACQ',
'PRO AC BM ACQS',
'PRO AC BM ACQF',
'PRO AC B4M ACQ',
'PRO AC B4M ACQF',
'PRO AC B4M ACQS',
'PRO AC B3M ACQ',
'PRO AC B3M ACQF',
'PRO AC B3M ACQS',
'PRO AC BV ACQ',
'PRO AC BV ACQF',
'PRO AC BV ACQS')
AND A.pin_num =c.pin_num
)
AND A.ORIG_CAL_RUN_ID=A.CAL_RUN_ID;