SQL Server, Interleaved execution feature and the multi-statement table valued function (MSTVF)
Hi Guys, January is starting while February is coming and the days slowly begin to get longer! Today we will talk about interleaved execution , a feature introduced in SQL Server 2017 In many previous posts they had already talked about the news that the 2017 and 2019 versions of SQL Server had brought us. In the last article of this series we talked about adaptive join (in the photo under the blue box on the far left): SQL Server and the Adaptive Join feature: "Adaptive Join" Vs. "wrong cardinality estimate" and "Uneven data distribution" Today to complete the features called "Intelling Query Processing" we will therefore talk about Interleaved execution. Interleaved execution Interleaved execution is a feature that is part of the Adaptive QP family of features where the acronym QP stands for Query Processing. The term adaptive means that the execution plan is now able to adapt itself according to the data it receives as input . In the case...