CSE Roadmap

Common tier · about 2 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Explain what statistics the optimizer keeps, and why it needs them.
  • Explain what a selectivity estimate is, and how it shapes a plan choice.
  • Describe at least two concrete reasons the optimizer's cost estimate can be wrong.
  • Connect a bad optimizer estimate to a poor plan choice visible in an execution plan.

Earlier pages in this level described the optimizer choosing among join algorithms and scan methods based on "estimated cost." They never said where that estimate comes from. This page opens that up, and explains why the estimate is not always right.