[VOTE] Add has_null_bitmap feature flag in zone map details #8089
Closed
westonpace
started this conversation in
Vote
Replies: 5 comments
|
+1 |
0 replies
|
+1 |
0 replies
|
+1 |
0 replies
|
The vote passes. |
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
We recently made a change to zone maps so that they record the null bitmap in addition to stats. This makes it very easy to satisfy
IS NULLandIS NOT NULLqueries. However, at the time, we didn't update the details.I'd like to update the details to indicate when this null bitmap is present. This will help us with planning time decisions around whether we should use the index or not. Currently we use the index for
IS NULLbut not forIS NOT NULLbecause we assume the latter will be inefficient as zone maps are an inexact index. By adding this flag we will know when a zone map is new (and thus efficient) so we can make the right choice at planning time.The flag is backwards and forwards compatible.
Backwards: If the flag is not present we assume there is no null bitmap.
Forwards: Unknown flags are ignored during details deserialization. The null bitmap can be safely ignored by a reader.
All reactions