oracle update语句优化
update t_fim_work_time_list_app a set a.accept_payment_type1=
(select t.record_id from t_fim_accept_payment_type t
where t.accept_payment_type1=pPaymentType1
and t.accept_payment_type2=pPaymentType2),a.accept_payment_type2=a.accept_payment_type1
where a.type=pType and a.asset_type_num=pTypeNum
and a.worktimelist_record_id in
(select l.record_id from t_fim_work_time_list l
where l.cost_month=pCostMonth);
谁能告诉我这个怎么优化!