In SQL Server 2017, the query optimizer can now sense a bad join choice in a plan and dynamically switch to a better join algorithm during the execution of the code. This addresses some common ...