2.1 Building Execution Plans Part 2 (22m)

Now let’s step through an execution plan in minute details to see where the estimates from each operator come from, and how they can go wildly wrong. If you want to follow along in SSMS, here’s the query: Transact-SQL SELECT Location, COUNT(*) FROM dbo.Users GROUP BY Location ORDER BY COUNT(*) DESC OPTION (MAXDOP 1); 12345…