Why do so many people prefer columnar databases? To my understanding, people prefer columnar databases because they are faster for querying due to the fact that the cpu would be able to cache the next values predictably.

If the speedup comes from caching, wouldn’t row-based databases be as effective for querying? the jump in memory is of a predictable size (exactly 1 row’s memory) between each value in a column -> meaning the cpu would also be able to cache the the next values.