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);
谁能告诉我这个怎么优化!Oracle性能优化
(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);
谁能告诉我这个怎么优化!Oracle性能优化
如果测试数据能一起上来那最好
再就是表及数据情况最好能提供下。