SQL Server 2017 and Azure SQL Database introduce a new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions. For the first version of this adaptive query processing feature family, we will have three new improvements—batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table valued functions.
Learn more about adaptive query processing.
Learn more about batch mode adaptive joins.
Learn More about batch mode memory grant feedback.