摘要:
bk1gx7xwj9du6SELECT * FROM HEADERS GJH WHERE ATTRIBUTE10 IS NULL FOR UPDATE 优化建议如下: 短期来说:建立一个索引来优化:create index idx_test_2 on HEADERS (ATTRIBUTE10,1); 阅读全文
摘要:
#####setting 1create table t as select * from all_objects where 1 =2; ###.模拟逐行提交的情况,注意观察执行时间DECLAREBEGINFOR cur IN (SELECT * FROM t_ref) LOOPINSERT IN 阅读全文