SQLKnowItAll (7/31/2012)
Grant Fritchey (7/31/2012)
One is estimating 230000 rows and the other is estimating millions. That is either a difference in data or in stats on the data. Must be. No other options.Or a slight difference in the query resulting in an accidental crossjoin(s)? To the OP, I'm not suggesting you are lying about the queries being exactly the same, its just that we all make mistakes (from time to time lol) and there are few other explanations.
Could be, but I compared the two queries. They look the same. I'm still on stats. Gotta be.
"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