Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters. Read more about parameter sniffing and how to avoid it from here.
No comments:
Post a Comment