Monthly Archives: July 2014

Disable indexes for data load

investigate index disable options in Oracle 11g. Short answer – it works mostly nicely. Example (a full test script is given bellow): alter index test1_i1  unusable; insert /*+append*/ into test1 select * from dba_objects where rownum<=1000; commit; alter index test1_i1  … Continue reading

Posted in Uncategorized | Leave a comment