Level 7 - ArchitectDebugging Questionsm5 plan forensics production tuning
Debug Plan Regression from Stale Statistics
A query switched from index seek to full scan after large data change. Diagnose and provide immediate SQL/ops fix.
Schema Context
orders(order_id, status, created_at, total_amount)