• I'm not sure what that second bullet point means. Perhaps it's advising you to create the clustered index first and all non-clustered indexes afterwards. As for whether to drop indexes, load, then recreate indexes, give it a try and see what works best. Be careful if any of the indexes enforce primary key constraints, for example, and make sure you recreate them in the order described above.

    John