Level 9 - DistinguishedScenario-Based Questionsm1 optimizer cardinality internals
Plan Instability from Parameter Sniffing
Scenario: Same prepared statement is fast for most tenants but times out for one large tenant. Explain how you would stabilize plans without hard-coding one tenant-specific query.