Intelligent Query Processing en édition Standard
Les fonctionnalités d’Intelligent Query Processing de SQL Server 2022 disponibles ou non en édition Standard, dans un tableau tiré de la doc Microsoft.
Tableau des fonctionnalités IQP
| Feature | 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 row store | 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 |