Markus Winand

Shaping the Optimizer's Search Space
About the Webinar

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, we’ll see how indexing affects this cage and learn how to shape the search space to bring the best execution plan within the optimizer’s reach.

About Presenter

Markus Winand teaches efficient SQL. He covers both aspects: the development time to accomplish a task using SQL as well as 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.