Is it better to create an index before filling a table with data, or after the data is in place?

Viewed 52823

I have a table of about 100M rows that I am going to copy to alter, adding an index. I'm not so concerned with the time it takes to create the new table, but will the created index be more efficient if I alter the table before inserting any data or insert the data first and then add the index?

5 Answers
Related