Level 9 - DistinguishedDescriptive Questionsm1 optimizer cardinality internals
Cardinality Misestimation and Wrong Join Plans
Explain cardinality misestimation, how it leads to poor join plans, and one practical first mitigation you would deploy in production.