Level 8 - PrincipalDebugging Questionsm1 distributed data architecture
Debug Cast on Shard Key
Fix query so shard index is usable: SELECT * FROM tenant_orders WHERE CAST(tenant_id AS TEXT)='42' AND order_ts >= CURRENT_DATE - INTERVAL '1 day';
Schema Context
tenant_orders(order_id, tenant_id, order_ts, amount)