Index rebuild performance increase

Question

Index rebuild performance increase

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 1

Heh.. Yes! Index fragmentation and out of date are the MAIN performance problems for a system, just after really poor design of tables and/or poorly written queries.

You can find the most demanding queries, or slower queries in your system, and check the execution plans to ensure the statistics are up-to date, and if the indexes are used (scans vs seeks). Looking at the most expensive queries usually tells you a lot about the slowness of a system.

Cheers,

J-F

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 2

Is it possible fragmented indexes can cause a noticeable decrease in DB performance?

Yes,

Merely having Indexes will not keep the system at high performance, with the increase in the data in the underlying table, the Indexes keeps fragmented.

Index rebuild will recreate the Indexes and all underlying stats, so it is a good maintenance practice to reindex the or defrag the Indexes regularly.