?? ????, ??????? ?? ??? ???? ????? ????? ????? ?? ? Database-?? ???????. ????? ??????? ?? ?????? ????? ????? ???????????? ???? ????? ??????????, ???? ????? ?????? ??????? ??????? ??????. ???? ??????? ????? ?? ???????? ??????? ? Query Plan Cache , ????? ??? ????????? ??????: 

SELECT ClientId
FROM clients
WHERE (StateId = 2) and (TransactionId = 5)

SELECT ClientId
FROM clients
WHERE (StateId = 2) and (TransactionId = 6)

SELECT ClientId
FROM clients
WHERE (StateId = 2) and (TransactionId = 7)

SELECT ClientId
FROM clients
WHERE (StateId = 2) and (TransactionId = 8)

??? ????? ??????? ????.  ???? ??????? ????? ????? ???? ?? ????? ?????.  ??? ????? ????? ??????, ?- Query Optimizer  ?? ???? ?????? ????? ???? ?????? ???? ????? ?? ?????? ????.  ????, ????? ????? ??? ? Query Optimizer  ???? ?? ?????? ????????, ???? ??????? ????? ?????? ???? ???? ????? ???? ?? ??? ????. ????? ?? ??????  Parameterization, ??? ?????? ??????? ????????.  ????? ??????? ??????? ?????? ????? ??:           

DECLARE @a, @b int;

SELECT ClientId
FROM clients
WHERE (StateId = @a) and (TransactionId = @b);

  ?? ????? ?????? ????, ??? ?? ??? ???? , ?????? ?????:           

1. ???? ??? ????? ??? ???????: ?????? ???? ??? ?????? ????? ?? ???  Parameterization.
2. ?????? Parameterization ? Database – ??????? ???????? ?? ?? ??? ?????????.
3. ?????, ????? ????? ?????? ?????? ?? ????? ??????????? ??????? ?????? ??? ???? ??? ???? ??? ?????? ? Database.     

Parameterization – ??? ????           

???? ?????, ???? ?? ?????????? ?? ????? ?????? ?????? ?? ?????? ??????, ??? ???? ??????? ????? ???? ???, ????? ?????? ??? ????? ?????? ???? ???? ?? ?????? ?????. ????, ????? ????? ?? ??????? ?? ?????????? ???? ????? ?????? ?????? ???. ?????? ??????? ????? ?? ????? Execution Plan. ??? ???? ?- Plan ????? ???? ?????? ???? ????? ??? ????? ???? ????? ???? ?? ?????? ?? ???????           

?????, ?????? ????? ??? ?- Execution Plan ????????? ????? ?? ?? ?????? ????????, ???? ???? ???????:           

1. ???? ?? ???? ??? ????? ?? ???????, ?- Execution Plan  ????????? ????? ?- Indexed View ??? ??? ?? ???? ?? ??? ?????? ????? ??? ?????? ?? ???????.
2. ?????? ?? ???? ???? Partitions ?? ????? ????? Execution Plan ???? ???? ???? ????? ??????? ? Partition?? ?????.
3. ?????, ????? ??? ?? ??? ????? ?? ??????? ????? ???? ???? ?? ?????? ??-Query Optimizer ????? ??? ?????? ? Index, ????? ??? ??? ????? ???? ???? ?? ?????? ??? ????? ???? ?????? ? Index.
4. ????? ??? ???? ?? Filtered Index ? Execution Plan ???? ????? ???? ???? ?? ??? ??????.

????? Parameterization ? Database           

??? ??????, ?? ???? ???? ???? ?????????? ?? ???????? ??? ?? ?????? ??? ???? ?? ?????????? ??? ???? ????? ??? ?Database . ?? ????? ??? ???? ???? ??????? ????? ???????????. ??? ???????? ??:           

1. Simple Parameterization – ???? ?????? ???????????? ??? ????? Database. ?????? ??? ???? ?????????? ???????? ?? ??? ????? ?????? ? Execution Plan ?? ????? ?????? ????????????. ?????, ?????? ??? ??????? ?????????? ??:
2. Forced Parameterization – ??? ????? ?????, ?????? ??? ??????? ?????????? ??? Simple Parameterization ??????? ????, ?????? ??? ??????? ??????? ????? ???. ??? ????? ?????? ?? Forced Parameterization ??? ???? ???? ???? ????? ???? ???? ???????, ?? ????? ??????? ??? ???? ??????? ?????? Plan ????? ???? ??? ???????????. ??? ???? ???? ????? ?????? ???????????? ? Simple ? Forced ??? ????? ?? ??????. ?? ? Forced Parameterization ?? ????? ??? ??????????? ?? ???????, ?? ?????? ?? ????? ??? ???? ????? ?: http://technet.microsoft.com/en-us/library/ms175037.aspx

DECLARE @statement nvarchar(max);
DECLARE @parameters nvarchar(max);

EXEC sp_get_query_template
N'SELECT ClientId FROM clients WHERE (StateId = 2) and (TransactionId = 8)',
               @statement OUTPUT,
                @parameters OUTPUT;   

EXEC sp_create_plan_guide N'ForceParameterizationPlanGuide', 
    @statement, 
    N'TEMPLATE',
    NULL,
    @parameters, 
    N'OPTION(PARAMETERIZATION FORCED)';  

SqlCommand command = new SqlCommand(String.Empty, connection);  

// Instead of id = 4, use parameterization: id = @id  
string query = "SELECT Name, DateTaken FROM Test Where id = @id;";
command.CommandText = query

// Enter value for parameter @id  
command.Parameters.Add("@id", SqlDbType.Int).Value = 4;
command.ExecuteReader();