Insert only option in Parallel jobs

csrazdan · Post by **csrazdan** » Wed Jan 19, 2005 1:40 pm

Hi All,
Is there a way to have only INSERT only option in Parallel job. I'm not comfortable in LOAD option as it requires the index to be disabled. Can anybody help in this.

Regards,
Shekhar

kcbland · Post by **kcbland** » Wed Jan 19, 2005 1:52 pm

A direct path load will disable the indexes, the only operation left for you is either conventional load or DML loading. If you use standard INSERT/UPDATE SQL then you won't have issues with indexes, you'll instead have performance issues.

vmcburney · Post by **vmcburney** » Wed Jan 19, 2005 4:14 pm

I once had a problem with a bulk load that disabled the indexes, when it tried to put the indexes back on it failed due to duplicates and the table became unstable. This told me there were problems with the load job and I had to add additional logic to dedupe the data. If I had been using insert/update instead of bulk load I may have been unaware of these duplicate keys and may have lost or overwritten important data.

There are thousands of DW projects out there using bulk loaders and disabling indexes due to the speed benefits. If your ETL design is good and your testing is sufficient then it shouldn't be a problem.