Intelligent Query Processing (IQP)
Comment utiliser le traitement intelligent des requêtes (IQP) dans Microsoft SQL Server.
Moins d'une minute à lire
Tableau des fonctionnalités IQP
| Fonctionnalité IQP | Description | Version SQL Server | Edition |
|---|---|---|---|
| Feedback CE | |||
Edition Entreprise
| 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 |