question on update sql

[Roger]

I have a sql in a siebel environment that is running for a long time.
Is there any way I can tune this sql :

UPDATE siebel.S_ORG_EXT BT
SET PR_POSTN_ID = (SELECT MIN(T_ACCNTPOST_POSITI) C1
FROM siebel.EIM_ACCNT_CUT
WHERE( T_ACCNTPOST_OUEXTI = BT.ROW_ID
AND ACC_PR_POSTN = 'N'
AND T_ACCNTPOST_OUEXTI IS NOT NULL
AND IF_ROW_BATCH_NUM = 5454
AND T_ACCNTPOST__STA = 3
AND T_ACCNTPOST__RID IS NOT NULL)), LAST_UPD = ?
WHERE (ROW_ID IN ( SELECT T_ACCNTPOST_OUEXTI C1
FROM siebel.EIM_ACCNT_CUT
WHERE( ACC_PR_POSTN = 'N'
AND T_ACCNTPOST_OUEXTI IS NOT NULL
AND IF_ROW_BATCH_NUM = 5454
AND T_ACCNTPOST__STA = 3
AND T_ACCNTPOST__RID IS NOT NULL)))
TIA

[Serge Rielau]

MERGE INTO siebel.S_ORG_EXT BT
USING (SELECT MIN(T_ACCNTPOST_POSITI) C1
FROM siebel.EIM_ACCNT_CUT
WHERE ACC_PR_POSTN = 'N'
AND T_ACCNTPOST_OUEXTI IS NOT NULL
AND IF_ROW_BATCH_NUM = 5454
AND T_ACCNTPOST__STA = 3
AND T_ACCNTPOST__RID IS NOT NULL
GROUP BY OST_OUEXTI) AS S
ON T_ACCNTPOST_OUEXTI = BT.ROW_ID
WHEN MATCHED THEN UPDATE SET PR_POSTN_ID = c1,
LAST_UPD = ?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html