SQL Practice Logo

SQLPractice Online

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)