A reporting dashboard worked with a few thousand rows but now takes 18 seconds after a year of growth. Users filter by organization, date, and status while the application loads several related tables for every row.
The scenario
Read the query plan before changing code. Consider composite indexes, selective filters, keyset pagination, aggregates, precomputed reports, caching, and the cost of ORM convenience. Explain how you would measure improvement without hiding a correctness problem.
The question
Which index would you add first, and what evidence would tell you it is no longer useful?
The official solution is not published yet.Think it through with the community first.
Community discussion
0 contributionsBe the first to share your reasoning.