SQL Practice Logo

SQLPractice Online

Level 10 - MasterOptimization Questionsm4 platform performance capacity strategy

Optimization: Better Refresh Strategy Query

Choose the better approach for incremental dashboard refresh and provide final SQL. Query A: INSERT INTO daily_sales_summary SELECT DATE(created_at) d, SUM(amount) FROM orders GROUP BY DATE(created_at); Query B: INSERT INTO daily_sales_summary SELECT DATE(created_at) d, SUM(amount) FROM orders WHERE created_at >= :last_refresh_ts GROUP BY DATE(created_at);

Schema Context

orders(order_id, amount, created_at), daily_sales_summary(d, total_amount)