Have you thought about having 2 indexed views, pointing to the different tables. One for loading the other for use. Then, once the new data is loaded, indexes...