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.