Enhancing query performance with Adaptive Query Processing in SQL Server 2017

added by DotNetKicks
9/28/2017 5:19:22 PM

1 Kicks, 197 Views

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 this first version of this adaptive query processing feature family, we have three new improvements: batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table valued functions.