Bain & Company interview question

designing a scalable web application. database indexing to improve query performance.