A critical production query that was performing well suddenly degraded from 50 milliseconds to 30 seconds after a routine data load. How do you diagnose and fix this?

Sample answer preview

A sudden query performance regression after a data load is a common and time-sensitive scenario for a mid-level DBA. The fact that it coincides with a data load narrows the investigation significantly.