Intelligent Query Processing in Standard edition
Which SQL Server 2022 Intelligent Query Processing features are available in Standard edition, in a table based on the Microsoft documentation.
IQP Features Table
| Features | Standard |
|---|---|
Approximate count distinct | Yes |
Approximate percentile | Yes |
| Automatic tuning | No |
| Batch mode adaptive joins | No |
| Batch mode memory grant feedback | No |
| Batch mode on rowstore | No |
| Cardinality estimate feedback | No |
| Degree of parallelism feedback | No |
Interleaved execution for multi-statement table valued functions | Yes |
| Memory grant feedback persistence and percentile | No |
Optimized plan forcing | Yes |
Parameter sensitive plan optimization | Yes |
| Row mode memory grant feedback | No |
Scalar UDF inlining | Yes |
Table variable deferred compilation | Yes |