Defragmentation best practices
Reorganize indexes with less than 30% fragmentation.
Rebuild indexes with 30% or more fragmentation.
Rebuild indexes during off peak hours.
Ignore indexes that have less than 1,000 pages.
Use online rebuilds if possible.
If the clustered index is being rebuilt, rebuild all indexes in the table.