- Rebuilding indexes that have an average fragmentation of over 30% (with ONLINE = ON), and reorganize indexes when they are between 5% to 30%.
- Reorganizing indexes once a day during off-peak hours.
- Rebuilding indexes once a week during off-peak hours. There is no need to reorganize indexes if they're rebuilt the same day.
- Rebuilding indexes only for the current month . There is no need to rebuild indexes on partitioned tables from previous months (if using partitioned tables by month (for table tab_event_log).