CODEWITHSUNDEEP
sql-serverindexingrebuild
Chintan Shah
Chintan Shah

Reputation: 13

Is it require to Rebuild NonClustered Index on MS sql server on Time interval

Database : MS SQL Server 2008 R2 or higher

I have one table with more than a million records. Clustered and NonClustered index create on this table. Daily around 1000-1500 records added in same table, after this report generate daily on this data.

Do I have to rebuild non clustered index after insert records and before generate the reports? OR rebuild index On weekly basis?

So that report output comes quickly

Upvotes: 1

Views: 2603

Answers (1)

EzLo
EzLo

Reputation: 14189

Is it required?

No, but it's highly recommended to keep an eye on fragmentation levels. The more operations (inserts, deletes and updates) you do on columns that are part of the index or included in them, the more likely it is to raise fragmentation.

Having fragmented indexes will impact on performance at certain thresholds. As Rajat mentioned, the challenge relies on knowing how often you need to rebuild them and when. The timing depends on your weekly, daily or even hour by hour workload and the size of your tables. How often to do it will depend on the amount of operations done at the records and the performance requirements you have.

Upvotes: 2

Related Questions