Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


    • 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).

table maintenace
table maintenace
Table Maintenance