Optimize User-and-Region Queries on a Million-Row Table
Company: J.P. Morgan
Role: Software Engineer II
Category: System Design
Difficulty: medium
Interview Round: Onsite
Overview: Design an evidence-driven optimization plan for user and regional queries on a million-row table, comparing indexes, partitioning, sharding, and replication under skew and writes.
Read the full J.P. Morgan Software Engineer II interview experience this question came from