Level 7 - ArchitectDebugging Questionsm1 indexing strategy
Debug OR Predicate That Defeats Index Path
Fix query with unstable plan: SELECT order_id FROM orders WHERE customer_id = 77 OR status = 'FAILED' ORDER BY created_at DESC LIMIT 100;
Schema Context
orders(order_id, customer_id, status, created_at)