Indexing strategy for large-scale query optimization
Filed under Paytm
The question
Given two relational tables and high query traffic, describe how to improve performance using indexing. Specify the index type, target attributes, justification, and write the SQL query to create the index.
No write-up yet. Related questions below have one.
Related Paytm questions
Collected from public candidate posts and coding forums. Updated Nov 2026.