Using Open Source Products to Collect Performance Metrics by Tracy Boggiano
Feb 12, 2019 - 56:55
Radio and PodcastLive Radio & PodcastsTechnology
The Problems With Optional Operators by Erik Darling and Joe Obbish
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....
About This Episode
The Problems With Optional Operators by Erik Darling and Joe Obbish is an episode from GroupBy – Free SQL Server Training by Brent Ozar. The optimizer has options. Not every option is optimal. Optimistic query tuners hope that the optimizer...
Podcast
This episode belongs to GroupBy – Free SQL Server Training.
Listen Online
Use the player on this page to stream the episode online.
Episode Details
Published Jan 29, 2019, 01:02:24 long, audio available.
Related Episodes
Continue listening to more episodes from GroupBy – Free SQL Server Training.
Columnstore Indexes: What are waiting for? by Niko Neugebauer
Feb 5, 2019 - 01:18:35
How to get your dream job: Resume & job hunting tips by Andy Mallon
Jan 22, 2019 - 52:59
New Engine Features in SQL Server 2019 by Aaron Bertrand
Jan 8, 2019 - 54:09
An Introduction to Partitioning by DBAfromthecold
Oct 23, 2018 - 57:05
Make Your Own SQL Server Queries Go Faster by John Sterrett
Oct 16, 2018 - 01:03:28
T-SQL Tools: Simplicity for Synchronizing Changes by Martin Perez
Oct 9, 2018 - 01:04:12
Questions About This Episode
What is The Problems With Optional Operators by Erik Darling and Joe Obbish about?
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.
Where can I listen to The Problems With Optional Operators by Erik Darling and Joe Obbish?
You can listen to The Problems With Optional Operators by Erik Darling and Joe Obbish online on Radio and Podcast. Open the player on this page to stream the available audio.
Which podcast is The Problems With Optional Operators by Erik Darling and Joe Obbish from?
The Problems With Optional Operators by Erik Darling and Joe Obbish is an episode from GroupBy – Free SQL Server Training by Brent Ozar.
How long is this episode?
This episode is 01:02:24 long.
When was this episode published?
This episode was published on Jan 29, 2019.
Can I save The Problems With Optional Operators by Erik Darling and Joe Obbish for later?
Yes. Use the heart button on the episode page to add it to your favorite episodes list.
Are there related episodes from GroupBy – Free SQL Server Training?
Yes. This page shows related episodes from GroupBy – Free SQL Server Training when more episodes are available from the podcast feed.
Quick Answers About This Episode
Where can I listen to The Problems With Optional Operators by Erik Darling and Joe Obbish?
You can listen to The Problems With Optional Operators by Erik Darling and Joe Obbish on this page when the episode audio is available from the podcast feed.
Which podcast is this episode from?
The Problems With Optional Operators by Erik Darling and Joe Obbish is from GroupBy – Free SQL Server Training by Brent Ozar.
What are the episode details?
Published Jan 29, 2019 and 01:02:24 long