HotshardLearn ↗Columnar StorageLAYOUTENCODESCAN

Columnar Storage — pick a scenario

0/4 done

Pick one and press Start, then click Next › to step through it.

Watch for

Each column lifting out of the rows into its own contiguous stripe.

More about this scenario
You'll learn

Why the physical arrangement decides which queries are cheap: rows together suit one-row reads, columns together suit scans.

How it runs

Transpose the table so every value of a field lands beside its neighbours in one place.