Log in

No account? Create an account
10 January 2014 @ 07:39 pm
Database indexes: to rebuild or not to rebuild?  
Every Sunday winservice runs run database indexes rebuild on my database.
It seems to be helping to prevent performance issues on big tables that are frequently updated.

But still I have my doubts if weekly index rebuild is the right thing to do.
DBAs' opinions are split:
in read-heavy databases you want to regularly rebuild or reorganize your indexes...
In databases that experience roughly equivalent read and write activity, or in databases that are write-heavy, you are likely harming your database's performance by rebuilding indexes regularly.
In your question you mention SQL Server and I do wonder if there is something fundamentally different about that platform that makes it different to Oracle, as this question is one that tends to polarise the two sets of DBAs

What do you think?
Clean and sober: aboutloveanspa on January 11th, 2014 01:54 am (UTC)
I think you need to evaluate measurable results and decide what suits your system best. DBAs love to create controversy by half truths or right-out myths.
Dennis Gorelik: 2009dennisgorelik on January 12th, 2014 02:47 pm (UTC)
Do you mean "Measure database performance before and after rebuilding indexes"?
Clean and sober: aboutloveanspa on January 12th, 2014 03:55 pm (UTC)
Ol Korrekt