For fast loading data you have to temporarily drop the index(s) and recreate after data load so that import of bulk data will be faster and make sure that recovery model has been set to bulk logged before data load and once the load task has been done st load is completed ensur that index are recreated and run the maintenance jobs(reindex, update statistics and backup jobs)