One of the great features that comes with SQL Server 2022 is Parameter Sensitive Plan Optimisation.

Although the name may sound confusing, I will try to explain it as simply as possible.

As we know, stored procedures in SQL Server are much more useful than ad hoc queries due to the advantages they offer in terms of performance and security.

You can see the difference between a stored procedure and an ad hoc query in the image below.

SQL Server 2022 ile Gelen Muhteşem Özellik, Parameter Sensitive Plan (PSP) Optimization