title: disable or drop the index in ETL stage load
body: <p>The T-SQl procedure truncate a stage table and insert data into the stage table.What is the best deign pattern to follow in this ETL stored procedures</p>
  
  <p>disable and enable the index 
    or 
   drop and recreate the index</p>