advancedDatabase Optimization Techniques
How do you archive historical data to keep the working table small and fast?
Tests whether you know moving cold data to a separate archive table keeps hot-path queries fast on the active table.
This is a Pro question
Sign in, then upgrade to Pro or Power to unlock this question and the full Interview Prep bank.
How do you archive historical data to keep the working table small and fast?