1

Many features have been released starting from SQL Server 2017 to SQL Server 2022 as part of the 'Intelligent query processing' family. Which ones are Enterprise only, and which are available in the Standard Edition of SQL Server?

1 Answer 1

2

Reference: Editions and supported features of SQL Server 2022

Enterprise Edition Only:

  • Intelligent Database: Batch mode adaptive joins
  • Intelligent Database: Batch mode memory grant feedback
  • Intelligent Database: row mode memory grant feedback
  • Intelligent Database: memory grant feedback persistence and percentile
  • Intelligent Database: cardinality estimate feedback
  • Intelligent Database: degree of parallelism feedback
  • Intelligent Database: batch mode for row store

Available in All Editions:

  • Intelligent Database: Interleaved execution for multi-statement table valued functions
  • Intelligent Database: approximate count distinct
  • Intelligent Database: approximate percentile
  • Intelligent Database: scalar UDF inlining
  • Intelligent Database: parameter sensitive plan optimization
  • Intelligent Database: optimized plan forcing
3
  • Why do some have “Intelligent Database:” and others not? Jun 2, 2023 at 22:08
  • Don't know. That is how it is defined in the reference page. Which is not same as learn website about IQP features. I will inquire about this via github. Jun 2, 2023 at 22:22
  • @ErikDarling answer update. Submitted a PR and was merged. All IQP features are preceded with the same wording on learn website. Jun 8, 2023 at 18:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.