I have around 800 indexes every 15 days we rebuildRegular index rebuild are very important. They ensure DBAs have something to do.
them, how do i know the particular indexes to rebuild
daily as required.
Why ? Have you some clues about that ?I am giving suggestion to rebuild daily.
I worked on many huge databases with a high rate of insert/delete without have to rebuild indexes to improve notably performance. There are others ways.With heavy DML's you have to rebuild indexes
What's the experience if you fall in some Rule of Thumb, which doesn't help at all to solve perf issue.If performance suffers then you have to put your experience rather than DOC's
I am giving suggestion to rebuild daily.I know many consultants who like this attitude. Make the DBA waste all his time so consultants MUST be hired to get anything real accomplished. <g>
With heavy DML's you have to rebuild indexesAbsolutely correct, once in a while - depending on the pattern of DML. For many, many kinds of DML and for most applications, rebuilding indexes is simply a way to prove to the users that "system's unavailable - we are working on it"