存储过程 速度很慢
ZJB11 2007-03-07 05:41:26 create or replace trigger tri_insert_dba01_air
after update on dba01
for each row
begin
insert into dba01_temp1 (rq,jh)
values(:new.rq,:new.jh);
pro_dba01_lhcyb1();
end tri_insert_dba01_air;
触发器
create or replace procedure pro_dba01_lhcyb1 is
rq date;
jh dba01.jh%type;
begin
select rq,jh into rq,jh from dba01_temp1;
update lhcyb1 set rcyl='123' where rq=rq and jh=jh;
--commit;
end pro_dba01_lhcyb1;
存储过程
不调用速度还行,一调用就接近死机,表有索引。
测试其中的sql,在pb中很快,在pl/sql中测试就很慢,很奇怪,跟pl/sql设置有关吗?