Improves the query performance when an optimized bitmap filter is applied to a query plan in SQL Server 2016 and 2017

Applies to: SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise

Summary


When a query plan uses a batch-mode hash join where one of the inputs is an optimized bitmap filter with an underlying bookmark lookup or key lookup in Microsoft SQL Server 2016 and SQL Server 2017, inaccurate estimations are produced. This update improves the query performance for the scenario.

Resolution


This improvement is included in the following cumulative update for SQL Server:

       Cumulative Update 6 for SQL Server 2017

       Cumulative update 8 for SQL Server 2016 SP1  

Note:

Status


Microsoft has confirmed that this is an improvement in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.