Slow query after upgrade
and action2.actn_dt = (SELECT MAX(a5.actn_dt)
FROM cat.action a5
WHERE a5.clm_no = action2.clm_no
and a5.actn_typ_cd= 'AS'
and a5.actn_dtl_cd in ('AJ', 'GD', 'CW', 'TB', 'MT', 'MP', 'BT', 'CA', 'MV','Z9', 'DY','MS')