There are many times when a developer realises that this snippet is not performing the way it was expected to . This happens as early as dev or unit testing cycle . This is the best time to get hold of those performance bottlenecks by using the most accessible performance tuning option "The Graphical Execution Plan".
Â
It is a one click operation to get to the plan but the terms like Seek, scan , Book mark Lookup , RID lookup and many more soon start puzzling the developer.
This session is aimed at making the developer aware of those terms and using this knowledge decipher the plan.