Questions tagged [adaptive-joins]

Use for questions regarding Batch Mode Adaptive Joins in SQL Server 2017

Filter by
Sorted by
Tagged with
9 votes
1 answer
457 views

SQL server 2019 adaptive join poor performance

I upgrade SQL Server from 2016 to 2019, the query plan of my query changed and it used adaptive join, but unfortunately the duration of query increase to 1 minute from 1 second, I changed the join ...
  • 91
5 votes
1 answer
1k views

SQL Server 2017: How do Batch Mode Adaptive Joins work?

Batch Mode Adaptive Joins are part of a family of features in the 2017 query processor that consists of: Batch Mode Adaptive Joins Interleaved Execution Batch Mode Memory Grant Feedback So how do ...
  • 34.4k