SQL Server 2016: Batch Mode Operators and the Query Optimizer
Jul 20,
2016
Previously, we’ve spoke of the value of batch mode processing in achieving optimum performance for analytical queries. Of course, a feature is worthless if the SQL Server query optimizer does not decide to use it. We also mentioned the curious fact that while the presence of a columnstore index is required for the optimizer to […]