Parameter Sniffing vs Parameter Sensitive Plan Optimization

SQL Server 2022 introduced the concept of Parameter Sensitive Plan Optimization. In this session, we'll look at what exactly Parameter Sensitive Plan Optimization is, and see how effectively it solves the old problem of parameter sniffing