Set Parameterization to Simple in SQL Server - Database Reference Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License

Parameterization is the process of substituting literal values with parameters (e.g., @p1). It allows SQL Server to create a single query plan for all queries with the same syntax, even if different literal values are used. Two options exist: Simple and Forced. OnBase may not benefit from Forced parameterization being enabled, and in some cases the Forced setting has caused queries executed by the software to perform poorly. Leaving the parameterization setting at the default setting of Simple allows SQL Server's optimizer to make better decisions when choosing a query plan because it can make better use of statistics using the literal values instead of parameters. Additional information regarding parameterization can be found in the Microsoft Docs SQL Server documentation.