Expected optimizer facts are assertions only.

highlighted = computed this step

Honest by construction

Expected optimizer facts are assertions only.

compiler is source of truth\text{compiler is source of truth}

Render checked estimates

The real-speed claim flag is no.

speed claim is no\text{speed claim is no}

Optimizer-choice examples are named toy estimate-model outputs; they are not benchmark results, database-product claims, hardware claims, or real speed predictions.

Honest by construction: table statstablerolerowCountdistinctKeysOrdersleft_after_filter_input126Customersright_join_input88 filter estimatelabelinputRowsselectivityestimatedRowsstatus filter121/43 plan estimate rowsplanformulaleft/buildright/probeestimatedWorkchosennested_loop_joinfiltered_left_rows * right_rows3824nohash_joinbuild_rows + probe_rows8311yes estimate factsfactvaluemodelNametoy_optimizer_estimate_v1leftRows12rightRows8selectivity1/4filteredRows3nestedLoopWork24hashJoinWork11chosenPlanhash_joinrealSpeedClaimnoproductClaimnorequiresBenchmarkForSpeedyes

Try to tamper

Wrong expected facts, derived sidecars, fractional estimates, missing keys, bools, floats, and unsupported keys fail closed.

tamper rejected\text{tamper rejected}

Summary

The book shows one exact estimate model, not a product optimizer.

scoped estimate model\text{scoped estimate model}