โ† Paytm questions

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.