see i am not in favour of diasble the index (clus + non clus both ) , as you wil start the insert, the data will get sorted as per clus index and non clus index will also get organized acordingly. but one thing you need to assure that you should some mechanism for population like "batch insert approach" in this way you wil manage the load of resources particulary tlog. 🙂