Level 7 - ArchitectScenario-Based Questionsm1 indexing strategy
Scenario: Index Budget on Write-Heavy Ledger
ledger receives 50k writes/sec. Read queries filter account_id + posted_at range and occasionally status. You can keep at most two secondary indexes. Propose index plan and trade-off.
Schema Context
ledger(entry_id, account_id, posted_at, status, amount, txn_type)