SQL Server 2019: Intelligent Query Processing in Action

Intelligent Query Processing in SQL Server 2019 automatically optimizes queries. Here’s how it works.

Features

• Batch mode on rowstore: Analytics queries faster
• Memory grant feedback: Auto-adjust memory
• Table variable deferred compilation: Better cardinality
• Approximate query processing: Fast approximations

Approximate Count

-- 97% accurate, much faster
SELECT APPROX_COUNT_DISTINCT(CustomerId) FROM Orders;

Enable for Database

ALTER DATABASE MyDB SET COMPATIBILITY_LEVEL = 150;

References

• IQP Documentation