Community

What is plan regression in SQL Server?

(Jovan Popovic) Plan regression happens when SQL Server starts using the sub-optimal SQL plan to execute some T-SQL query. Usually you will see that some T-SQL query is executing really fast, but then it gets slower without any obvious reason. In this post you will see how can plan regression happen

Read More - Register for Free Membership