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)