What are the considerations when loading a large amount of data to a large table?
One thing to consider are the indexes because they need to get rebuilt. One advice I had from someone is to drop the index, load the data, and finally re-create the index. Is this faster than loading without dropping the index?
What other considerations or concerns are there? What about data isolation? If it take a while to load the data, are the users locked out from selecting from the table? I would try to test this, but not sure how I can come up with large enough data set to
View Complete Post