Columnar storage

Learn column-oriented storage.

Columnar storage keeps data by column, not row. Values from the same column sit together; this speeds up aggregate queries like SUM and AVG.

CREATE TABLE events (id INT, ts TIMESTAMP)
WITH (format = 'columnar');

Columnar speeds up aggregate queries.

The table events is created.

Columnar storage — details

Row-based storage suits OLTP; columnar suits OLAP. Columnar reads only the columns it needs; this makes wide-scan, few-column queries very fast.

Create the events table as columnar: WITH (format = 'columnar').

Show example solution

CREATE TABLE events (id INT, ts TIMESTAMP) WITH (format = 'columnar');

Columnar format

WITH (format = '____')

Show answer

WITH (format = 'columnar')