10. How Execution Plans are Made (10m)

Parse, Bind, and Optimize: SQL Server goes through a few steps, and then goes through that last one repeatedly, honing the plan until it finds a good-enough version.