>>How fragmented your indexes are?
>
>There are no special maintenance procedures in regards to that. The indexes have been created at first and the remain.
You need to run maintenance of indexes periodically. Most people recommend Olla Hallogreen (?) scripts, but I recommend Michelle Ufford scripts for indexes de-fragmentation. I posted link here before.
If it's not broken, fix it until it is.
My Blog