Friday, April 5, 2013

INSERT in PL/SQL... can be slow

Suggest Way for fast INSERTs
  • Mark indexes unuasble
  • Disable primary key
  • Alter table nologging
  • Do an insert /*+ append */ into table (select ..)
  • Enable primary key
  • Rebuild indexes nologging

No comments:

Post a Comment