In this episode, I hosted Markus Winand to talk about database optimizers. Markus teaches organizations how to use databases efficiently. He covers both aspects: the development time to accomplish a task using SQL as well as optimizing the runtime of the final solution. He also published the book "SQL Performance Explained" and is currently working on his next book, which is being published on an ongoing basis at http://modern-sql.com.

In this session Markus talked about database optimizers. In its quest for an optimal execution plan, the optimizer is jailed into a cage laid out by the SQL query and the physical database design.
As per definition, the optimizer can only find the best execution plan within this cage—not necessarily the absolutely best way to get the result. In this session, Markus shows how indexing affects this cage and talks about how to shape the search space to bring the best execution plan within the optimizer’s reach.

If you'd like to watch the recording of this webinar, or be notified of upcoming webinars, please register at http://www.prohuddle.com.