An intelligent query processing feature, available from compatibility level 140, that stops optimising part-way, executes a qualifying multi-statement table-valued function to learn how many rows it really returns, and then completes the plan.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Interleaved execution in context, with comparison tables and the common traps.
Terms in this definition
- Intelligent query processing
An umbrella name for optimiser capabilities, among them adaptive joins, OPPO, interleaved execution and feedback on memory grants, that improve query plans automatically, usually without code changes. Raising the compatibility level of a database switches most of them on.
- Compatibility level
Determines which Database Engine version a database's T-SQL and query processing imitate. Certain new functions,
REGEXP_LIKEamong them, won't work below 170. - MSTVF
A multi-statement table-valued function, which builds up and returns a table variable using several statements. The optimiser can't see how many rows it returns, unlike an inline TVF, a gap that interleaved execution helps to close.