dbs/mss/recompile_par_stmts

Parameter

dbs/mss/recompile_par_stmts

Short text

Recompile every parameterized statement.

Parameter Description

If this parameter is set then each and every dynamic (parameterized) statement will be different, because a counter is placed in a comment in the statement. This will prevent SQL Server from re-using the query plan.

Application Area

Database

Default Value

0

Operating System Restrictions

Windows NT

Database System Restrictions

Microsoft SQL Server

You May Also Like

Leave a Reply?