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