Whenever you're ready, walk me through how you'd approach this.
How do you handle data partitioning and indexing to improve query performance?