# Columnar Storage
![`smart`](./student-guide/diagram/ColumnarVsRowStorage_aa_001_20220527.png)
-----------------------------------------------------------
Insert 1 row: 
- Row based engine requires access to 1 data block only, while column based engine requires access to 3 data blocks.

Query analysis (without WHERE clause for this case): 
- Row based engine requires access to 3 blocks, while column based engine only needs to access 1 data block only.