Ever looked at a query plan and thought, "what does that little operator do?" or "why has the optimiser chosen that one?" or even "why is that one operator taking up such a large % of my plan?!"
In this tour of the query plan operators we'll look at what each of them do, how each of them work, why the optimiser chooses them for a specific task and in what circumstances and why sometimes they perform badly.
We will also look at how to encourage the optimiser how to choose the best operators for the job by changing the way the code is written.
Held mainly in management studio using lots of code and examples to make this session easier to follow