Table Rotation can be used for tables that:
  • Hold data that is only valuable for a limited period of time
  • Are written sequentially by inserting new rows
Table Extension can be used for tables:
  • That hold data that's organized by time
  • Where data is written and then never updated, or where updates are mostly focused on recent data
  • Where data is needed for a period of time (e.g., two years) and can subsequently be discarded or archived off the system