Batch Mode Bitmap Filter Should Not Reduce Costs of Key Lookups That Contain the Bitmap Column - by Joe Obbish

Status : 

 


6
0
Sign in
to vote
ID 3144542 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 11/29/2017 12:13:03 PM
Access Restriction Public

Description

The new bitmap filter introduced with batch mode can cause severe performance issues
depending on the indexing of the table on which the bitmap filter is applied.
In one scenario, a misplaced bitmap filter resulted in millions of unnecessary key lookups.
Go to the details for more information. It's rather tedious to describe the query plan in words.
Sign in to post a comment.