data-konzept

'As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new in 2017, represents a new direction. This set of features provides some flexibility for varying join types, multi-statement table valued functions, and memory grants. In this article, Robert Sheldon explains the three features that make up Adaptive Query Processing'...

https://www.red-gate.com/simple-talk/sql/database-administration/adaptive-query-processing-in-sql-server-2017/