I have findout the indexes from one database having fragmentation is less than 30 & greater than 5 using
dmv. Now I want to reorganize that all indexes for that I have created a script which will automatically reorganzise the indexes having avg.fragmentation is less than 30 & greater than 5. However I found that after reorganizing
activity count of indexes is increased. does reorganizing increase indexes? or before & after count of indexes should be same?