how to disable and enable all index during ETL in SQL


  • Hi,

    I have N number of indexes in SQL data base, i have around 60 fact and 30 dimension tables,  after one year now my loading time is getting more and more .  i am using ssis for data loading.  i am not rebuilding index every day but on weekend.

    i want to disable all indexes and enable after loading. how to disable all indexes on database and enable all after loading ?

    Monday, August 19, 2013 6:13 AM


All replies