Core concept

CBO picks based on stats. Broadcast when small enough.

Advertisement

How it works

Skew degrades partitioned. Broadcast memory-bound.

Advertisement

Trade-offs + gotchas

Star schema. Fact + dim joins.