performance of query decrease dramatically.
So we can use local values to copy these parametrs.
1 ALTER PROCEDURE [dbo].[CalculateSomething]
2 @myID INT
3 AS
4 BEGIN
5 DECLARE @myIDLocal INT
6
7 SET @myIDLocal = @myID -- If you this performance of query
8 -- will inctrease!
9 SELECT * FROM myTable WHERE ID = @myIDLocal