Everyday I truncate a table of roughly 40 millions rows, populate it and re-create the indexes.
If I restart the SQL server just before, the process take a bit more then 1 hour. After a week, the same process takes 2hours. I can't explain why the time of execution is increasing that much.
I think this it the creation of the indexes that takes more time.
Any idea where I can look at?