Re-indexing
-
Hello, we have created a job to automatically run re-indexing on some of the indexes, on a weekly basis. The outcome, is that some of the indexes are taking a longer time the second time around. We have collected data for 2 weeks now and running some analysis. Is there something like re-indexing too often not a good idea? They indexes are used quite often, so the plan for once a week re-indexing worked out. thanks!
-
Hello, we have created a job to automatically run re-indexing on some of the indexes, on a weekly basis. The outcome, is that some of the indexes are taking a longer time the second time around. We have collected data for 2 weeks now and running some analysis. Is there something like re-indexing too often not a good idea? They indexes are used quite often, so the plan for once a week re-indexing worked out. thanks!
Let's take a step back and see what is motivating you to re-index ? Re-indexing a table which does not change much (insert,update,delete) is a waste of time. Maybe you should consider using a threshold, like "fragmentation" to determine when you should re-index. Something similar to disk defragmenter; it analyzes your disk, then recommends you to either defrag or not defrag. Look at this article ... http://www.sql-server-performance.com/articles/per/index_fragmentation_p1.aspx[^]