Explain how columnar storage increases query speed.

1.	Explain how columnar storage increases query speed.
Answer» Since it dramatically reduces total DISC I/O requirements and the quantity of data you need to load from the disc, columnar storage for DATABASE tables is a critical factor in increasing analytic query speed. Each data block STORES values of a single column in MULTIPLE ROWS using columnar storage.

Discussion