Track · 1:44 · Liner note

Cross Join the Universe

Name: Cross Join the Universe
Duration: 1 min 44 s
Description: A cross join pairs every row of one table with every row of another, producing the Cartesian product, so the result grows multiplicatively.

A cross join pairs every row of one table with every row of another, producing the Cartesian product, so the result grows multiplicatively.

A cross join is the most literal version of asking what if we tried everything: two tables, every possible pairing. Used on purpose, it builds the date-by-product scaffold that makes a report complete even where nothing happened. Used by accident, it turns a thousand rows into a billion.

Cross Join the Universe is for deliberate ambition. Check the row counts before you run it, then enjoy how much of the map appears when you stop leaving combinations out.