How I Avoided a Full Table Scan on a 400 Million Row Table
This wasn't a case of premature optimization. The retention job had reached the point where it was no longer completing in production. At that point, finding a different approach became a necessity, not an optimization exercise.
