软件环境 Windows 2000 + Oracle9i
硬件环境 CPU 1.8G + RAM 512M
 
现在我们有2张表 如下：
T1--大表 10000笔 T1_FK_ID
T2--小表 5000笔  T2_PK_ID
T1通过表中字段ID与T2的主键ID关联
 
模拟数据如下：
--T2有5000笔数据
create table T2
as
select rownum id, a.*
 from all_objects a
 where 1=0;
 
-- Create/Recreate primary, unique and foreign key constraints
alter table T2
 add constraint T2_PK_ID primary key (ID);
 
insert /*+ APPEND */ into T2
select rownum id, a.*
      from all_objects a where rownum j;
update T1 set T1.Subobject_Name = (select T2.Subobject_Name from T2 where T1.ID = T2.ID)
where T1.ID >= i and T1.ID