Indexing strategy for large table and composite indexes
Filed under Paytm
The question
Discuss advantages/disadvantages of indexing. Given a table with 100 million rows and columns A, B, C with specific unique value counts, and frequent queries on all three, how should indexes be created and can composite indexes be created on A and B?
No write-up yet. Related questions below have one.
Related Paytm questions
Collected from public candidate posts and coding forums. Updated Nov 2026.