oracle表关联update和表建立索引

update A a set a.A2 = (select b.B2 from B b where b.B1=a.A1) where
exists (select 1 from B where B.B1=a.A1)

-- Create/Recreate indexes
create index t_source_phase_01 on t_source_phase (lineid)
  tablespace COMMON_CABLE
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

标签：