This probably won’t seem like a big deal soon
But I just got the optimizer to pick an Adaptive Join! It took a few tries to figure out what would cause some guesswork to happen, but here it is.
And here’s the tool tip info!
This is so cool! Now I can start picking apart the XML to add stuff to sp_BlitzCache.
In the XML, we have this information.
There also appears to be a whole XML path dedicated to the AdaptiveJoin, but I’m still working out what all goes on in there.
Thanks for reading!