一个sql语句:
insert into new_person_bonus_info (regionid,dept_id,dept_name,bankcard,bankid,bankname,promisee,name,
assess_year,assess_month,person_base_grade,person_safety_grade,month_work_hour,final_grade,
bonus_param,reduce_amount)
select
v.regionid,
v.dept_id,
v.dept_name,
v.bankcard,
v.bankid,
v.bankname,
v.promisee,
v.name,
v.assess_year,
v.assess_month,
v.person_base_grade,
v.person_safety_grade,
v.month_work_hour,
v.final_grade,
v.bonus_param,
v.reduce_amount
from v_person_bonus_info v
v_person_bonus_info是个视图,直接执行sql语句很快,但是,用这个insert。。。select。。。语句,就执行很久
也没有结束。
我trace了一下,结果如下:
请问,能看出啥原因吗
|