14
At the moment minimum usage parameter is hardcoded in the procedure for index selection and it's working fine if we want to defragment highly used indexes in the system. But for indexes with lower usage or not used indexes fragmentation will not run at all.

Highly fragmented indexes consume more disk space and it's a must-have option to defragment them from time to time to keep database growth under control. During my test, I was able to reduce used disk space by 25% by defragmenting all indexes.

We would like to have the option to lower the minimum usage parameter by system administration (including 0 value) to have the ability to make full defragmentation from time to time to avoid rapid database growth.
STATUS DETAILS
Needs Votes