SQL Practice Logo

SQLPractice Online

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)