Simple Parameterization and Trivial Plans — Part 2
SQL Performance
MARCH 29, 2022
Parameter Data Types. As mentioned in the first part of this series , one of the reasons it is better to explicitly parameterize is so you have full control over parameter data types. Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version.
90 
Let's personalize your content