Questions tagged [interleaved-execution]

Use for questions regarding Interleaved Execution in SQL Server 2017

Interleaved Execution occurs when the subtree for a Multi-Statement Table Valued Function is executed during query optimization to improve cardinality estimation and operator choices in the plan.

2 questions

votes

1 answer

SQL Server 2017: How does Interleaved Execution work?

Interleaved Execution is 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 does Interleaved Execution work?

asked Oct 04 '17 at 00:57

Erik Reasonable Rates Darling

45,549
14
145
532

vote

1 answer

Interleaved Execution not happening in SQL 2017 DB

We have a SQL Server 2017 database that was imported from a 2008 instance long ago. The compatibility level is set to 140 (confirmed by the execution plans), but no multi-statement TVFs are ever executed with interleaving and always have cardinality…

sql-server sql-server-2017 interleaved-execution

asked Dec 04 '24 at 14:10

Simon Bramley