SQL_Surfer - Monday, July 17, 2017 12:07 PM
That wouldn't, but differences in the MAXDOP setting or the Cost Threshold for Parallelism could. Are these the same.
Also, has anyone checking the plans looked at the ANSI settings, etc., to see if there are possible reasons the plan compiling two different ways apart from statistics (which seems to be the likely culprit). I'd do this but since the plans aren't in standard format, I can't help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning