Search notes:
SQL Server: performance tuning
Intelligent Query Processing (IQP)
IQP Features
IQP features include
Batch mode adaptive joins (dynamically select
join
type at runtime based on input data)
approximate count distinct (
SQL aggregate function
approx_count_distinct
)
batch mode for row store
Interleaved execution for multi-statement table valued functions
memory grant feedback (batch mode)
memory grant feedback (row mode)
scalar
UDF
inlining
table variable
deferred compilation
Enable IQP on a database
alter database tq84_db set compatibility_level = 150;
Index