Tag Info

New answers tagged


As is mentioned in another response, the answer to your exact question is implementation-specific. Different database vendors will likely give different answers to it. I'm not sufficiently familiar with other column-based database engines, but in DB2 with BLU acceleration you would still have indexes covering primary keys and unique constraints of ...


If you want to scan a subset of all data stored you need some kind of indexing structure. It does not have to be a B-tree. In a certain sense, partitioning or segment elimination is also a kind of indexing. There is nothing intrinsically preventing a columnar database to be stored in a sorted (or roughly sorted way). This would allow seeks to happen. That ...

Top 50 recent answers are included