Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch execution mode works and how you can use it to get faster query results on rowstore data. We’ll go over the restrictions and the prerequisites for enabling batch execution mode and understand it with an example.
Prerequisites for Enabling Batch Execution Mode
There are a few prerequisites before you can use batch mode. They are:
Compatibility Level – Batch execution mode requires a compatibility level of at least 150 to be enabled. Check your database compatibility level before enabling this feature.