CHAPTER |
|
28 |
Intelligent Query Processing |
In This Chapter
• Approximate Query Processing
• Table Variable Deferred Compilation
This chapter describes a group of sophisticated and related features called Intelligent Query Processing (IQP). The main goal of these features is to improve performance of existing workloads while requiring only minimal implementation effort to adopt the features. The following features belong to the Intelligent Query Processing family:
• Adaptive Query Processing
• Batch Mode on Rowstore
• Approximate Query Processing
• Scalar UDF Inlining
• Table Variable Deferred Compilation
The following sections describe these features ...
Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
