Search

Home > GroupBy – Free SQL Server Training > The Problems With Optional Operators by Erik Darling and Joe Obbish
Podcast: GroupBy – Free SQL Server Training
Episode:

The Problems With Optional Operators by Erik Darling and Joe Obbish
Category: Technology
Duration: 01:02:24
Publish Date: 2019-01-29 05:00:00
Description:

The optimizer has options.

Not every option is optimal.

Optimistic query tuners hope that the optimizer will make optimal choices.

Often, the optimizer will stick an optional operator in a plan that just doesn’t belong.

Sorts, Spools, Lookups, Tops, Aggregates, and Bitmaps can all end up where they don’t belong.

Opt out of bad powerpoint decks with this demo-only session!

Joe Obbish and Erik Darling will show you when the optimizer’s optics might require a trip to the optometrist.
Total Play: 0