vendredi 29 juillet 2016

disable or drop the index in ETL stage load

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

disable and enable the index or drop and recreate the index

Aucun commentaire:

Enregistrer un commentaire