In part 1 of my SQL ... table, you can see that there is a large amount of data skew: What this means is that the best execution plan for a parameter value of 1 or 2 would be for SQL Server ...