Senior Backend Engineer / Stage 2 · Data
Explain scans, estimates, statistics and plan changes
"Already know" meets prerequisites. "Not relevant" removes the topic from your total but leaves what builds on it waiting.
Self-check
- You complete one linked tuning exercise before revealing its solution. Compare estimated and actual row counts at the plan node that changes your decision.
- Evidence to include: Save the initial and revised query, real plan output and explanation. Describe why cost is not elapsed milliseconds.
Try it without the material first, then compare. Save your answer in your notes below. Report a problem with this self-check
Learning activities
6 activities- Not done6 min
- Not done12 min
- Not done6 min
- Not done7 min
- Not done3 min
- Not done5 min