What makes columnar databases faster for querying?
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.