On 11/24/21 1:15 PM, Godfrin, Philippe E wrote: [snip]
I dropped the unique index , rebuilt the other indexes and no change.
IMNSHO, this is the worst possible approach. Drop everything *except* the unique index, and then (if possible) sort the input file by the unique key. That'll increase buffered IO; otherwise, you're bopping all around the filesystem.
Using a bulk loader if possible would increase speeds -- Angular momentum makes the world go 'round.
