- Partitioning: Describe any partitioning strategy (e.g., date-based partitions) used to optimise query performance.
- Indexing and Caching: Discuss indexing on frequently accessed tables and caching strategies (such as Materialised Views) to enhance read performance.
- Data Pruning: Include any mechanisms for archiving or pruning historical data to maintain efficiency.
