Senior Backend Engineer / Stage 2 · Data

Explain scans, estimates, statistics and plan changes

CoreIntermediateDraft, not yet reviewed39 min of activities

"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

My notes

Saved on this device, synced when signed in
Esc
↑ ↓ to move↵ to open