Depending on fragmentation index level appropriated action will be taken (no action, rebuild or reorganize) If average fragmentation is less than 10% no action will be taken, if average fragmentation is between 10% and 30% index will be reorganized, finally
Read More...
