Database, Data Engineering, Dbms, Data Modeling, Data Management.
the bitmap-related aggregations are implemented with RoaringBitmap, which can deliver high performance especially when dictionary encoding produces dense values. As is mentioned, auto-increment columns enable fast dictionary encoding. I will put you into the context of user profiling to show you