DB2中存储过程执行慢问题故障处理(三)

2014-11-24 18:56:04 · 作者: · 浏览: 22
D = 11,155
Update: Table Name = PODS.T_ODS_PAR_CUSTMSG ID = 11,155
End of section


Optimizer Plan:
UPDATE
( 2)
/---------/ \
FETCH Table:
( 3) PODS
/-------/ \ T_ODS_PAR_CUSTMSG

HSJOIN Table:
( 4) PODS
/---/ \--\ T_ODS_PAR_CUSTMSG
TBSCAN TBSCAN
( 5) ( 6)
| |
Table: Table:
PODS PODS


T_ODS_PAR_CUSTMSG T_ODS_PAR_OCSACTIVEMSG