• Rebuild process is better when compared to reorg

    below are the runtimes of a non clustered index of row count 1114462

    rebuild 7 mins with maxdop 2 and sort in tempdb on

    reorg 15 mins with maxdop 2 and sort in tempdb on

    right now I am checking for fragmentation, if it is between 1 to 2% reorg else rebuild.

    I am going to change process to Rebuild indexes and update stats that are not related to Index without checking fragmentation, this way we save time on checking fragmentation which may be hour or more to verify all indexes