In my previous vlog, I showed how and why the optimizer uses a rowgoal in the execution plan when your query uses a TOP or FETCH expression. Those are the keywords where this rowgoal is very obvious.
Unexpected rowgoals
But it’s not always that obvious. There are several other situations where rowgoals can be used, and some of them can be very unexpected!
More of me?
Was this useful to you? Do you want to learn more from me?
You can click here to see an overview of my scheduled conference visits. If you attend one of those, you get a lot of other presenters and sessions thrown in as well!
To learn really everything about SQL Server execution plans, check out my video training. Over 20 hours of super high quality video content (and more will be added when ready).
Or you can hire me, for instance for custom built in house training, or if you just want me to fix your performance problems now.
