Level 10 - MasterOptimization Questionsm1 end to end data architecture
Optimization: Event-Time Filter Strategy for Serving API
Choose the better query shape for API serving and provide final SQL. Query A: SELECT tenant_id, COUNT(*) AS cnt FROM order_events WHERE DATE(event_ts) = CURRENT_DATE GROUP BY tenant_id; Query B: SELECT tenant_id, COUNT(*) AS cnt FROM order_events WHERE event_ts >= CURRENT_DATE AND event_ts < CURRENT_DATE + INTERVAL '1 day' GROUP BY tenant_id;
Schema Context
order_events(event_id, tenant_id, event_type, event_ts)