How Does a Hint Affect an Adaptive Join?

First published at 16:43 UTC on October 4th, 2018.
subscribers

Since adaptive joins can control their behavior, using either a hash or a nested loops, what happens when you start putting join hints into the mix. Let's explore that and see how the adaptive join, the execution plan, and the query performance…

MORE
CategoryScience & Technology
SensitivityNormal - Content that is suitable for ages 16 and over
DISCUSS THIS VIDEO