Tag: Execution Plans

SQL

Understanding Aggregate Operators

Post author By Andy B.
Post date Mar 12, 2024
1 Comment on Understanding Aggregate Operators

In the last post we looked at how TOP and MAX operators compared. We saw the execution plan for a MAX function used a Stream Aggregate operator which is one of two which we can use for aggregation I wanted to look at the two operators and how they perform the same tasks in different ways. The way they function is key […]

Tags Aggregate Operators, Execution Plans, Hash Match, Performance, Plan Operators, Querying, SQL, Stream Aggregate

SQL

A Bit About Trivial Plans

Post author By Andy B.
Post date Feb 20, 2024
No Comments on A Bit About Trivial Plans

A Trivial plan is created when SQL Server really doesn’t have any choice in how it’s going to execute. Here’s an example from the StackOverflow database with the indexes removed: There really isn’t any choice but a clustered index seek. It’s the only index and its about as effective as we can get given we’re filtering on […]

Tags Execution Plans, Optimisation, Querying, SQL, Trivial Plans