Level 9 - DistinguishedOptimization Questionsm5 distributed sql sharding consistency
Optimization: Routed Query vs Global Query
Choose better query for latency and consistency safety. Query A: SELECT * FROM ledger_entries WHERE user_id = 9001 ORDER BY created_at DESC LIMIT 100; Query B: SELECT entry_id, amount, created_at FROM ledger_entries WHERE tenant_id = 42 AND user_id = 9001 ORDER BY created_at DESC LIMIT 100;