Given a time-series metrics table with millions of rows per day, explain how you'd design indexes to optimize both real-time dashboard queries (last hour) and historical reporting queries (monthly aggregates).

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

Given a time-series metrics table with millions of rows per day, explain how you'd design indexes to optimize both real-time dashboard queries (last hour) and historical reporting queries (monthly aggregates).

Practice more