More than just setting up DBCC jobs
I want to cover Optimization more as an end to end task rather than a piece meal – setting up DBCC or Index Rebuil-ReOrg etc.
Database optimization should encompass all aspects of a Relational Database – including Hash Plans on Tables/Indexes/Pages etc.
Few of us in the industry are aware Statistics are important even when a table has no indexes – figure that.
I have seen that at multiple sites where previous DBA’s have setup Index maintenance plans thinking they were covered, but that was not the case.
Table with stale or old Statistics can cause immense delays in processing.
More on this in my next blog.