Local variables and their impact on execution plans in SQL Server Stored Procedure

0 votes

0 answers

25 views

sql-server-2012 execution-plan performance-tuning variable

                          If a parameter that is passed to stored procedure is assigned to a local variable and the local variable is used inside the stored procedure logic, will that affect the execution plan in any way? Is it a good practice to use them?
                        

Asked by lifeisajourney (751 rep)

Oct 28, 2022, 11:10 PM
Last activity: Oct 29, 2022, 02:08 AM

Local variables and their impact on execution plans in SQL Server Stored Procedure

Related Questions