SQL Server Simple and Forced Parameterization, what to use?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
3 years ago
I'm using NopCommerce v4.2 with SQLServer 2016.
I'm looking at the database to see if I can optimize it a bit more.

I've read this article: https://www.mssqltips.com/sqlservertip/2935/sql-server-simple-and-forced-parameterization/
Now I wonder if it is a good idea to set `Forced Parameterization`, currently my database is set to `Simple`.

Does anybody have experience with this?
3 years ago
I've not tried it, but to know if will have any benefit requires that one to examine the existing plans (for a variety of frequent queries), and see whether the simple parameterization is already in use.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.