Disable all indexes in one database
Way to check whether we make all indexes disable or not.
Rebuild all indexes in one database
note :
1)rebuild will make disable index become enable as well
2)after rebuild, index fragementation still high
- possible reason:
1. heap table - not clustered index
2. table is small