SQLTeam.com Logo

Return to Query Parameterization and Plan Cache

Query Parameterization and Plan Cache

Written by Guest Authors on 23 January 2007

This comes to us from the SQL Server Programmability and API Team Blog. They write "Using parameters or parameter markers in queries increases the ability of SQL Server to reuse compiled plans. There are two places where parameterization of queries can be done: on the client side application (or mid tier) or on the server side."