Why are columnar storage formats efficient for analytical queries?
- A Only the columns referenced are read, and similar values compress well together
- B They store fewer rows
- C They avoid indexing
- D They are always smaller
Answer
Only the columns referenced are read, and similar values compress well together
An analytical query touching three columns of a fifty-column table reads a fraction of the data a row store would.





