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:
http://dba.stackexchange.com/questions/4283/when-should-i-rebuild-indexes
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?
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:
http://dba.stackexchange.com/questions/4283/when-should-i-rebuild-indexes
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?
3 comments | Leave a comment