Insert with Append/Parallel/Nologging is best option. (BTW, 3 million is not a huge number of records).
funky... "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail." "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Forum Rules
Reply With Quote