This presentation is a short introduction to the two key questions that drive the optimizer - how much data do I have to visit and how widely scattered is that data? We will look at a simple model to demonstrate the way that the optimizer "thinks" when choosing an execution path, and then explain why the optimizer sometimes chooses very silly execution paths.

Check out the webcast schedule here.