Posts by Erik Darling

The Problems With Optional Operators

No Comments
Target Audience: Anyone who stares at query plans for a living. Abstract: 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…
Read More