SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedDebugging Questionsm5 distributed sql sharding consistency

Debug Unbounded Cross-Shard Fan-Out

Fix this pattern that triggers cluster-wide fan-out: SELECT * FROM orders WHERE customer_email = 'ana@example.com' ORDER BY created_at DESC LIMIT 20;

Schema Context

orders(order_id, tenant_id, customer_email, created_at, total)