Cardinality Estimation Feedback in SQL Server 2022
In SQL Server 2022, we have introduced a method of CE Feedback based on actual performance of the query over time.
Data platform
-
-
Memory Grant Feedback: Persistence and Percentile Grant
Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022. -
Intelligent Query Processing: degree of parallelism feedback
In SQL Server 2022, we introduced a new feature called DOP feedback. -
Intelligent Query Processing: feature family additions
SQL Server 2022 expands and improves query performance feedback mechanisms and adds two new features—parameter sensitive plans and optimized plan forcing.
Explore SQL Server 2025
Accelerate your AI application’s time to market by harnessing the power of your data and the built-in AI capabilities of SQL Server 2025, the enterprise database with best-in-class security, performance, and availability.
Connect with us on social