Whenever you're ready, walk me through how you'd approach this.
Describe the trade-offs between different database indexing strategies and how you choose for a given workload.