Core concept

Placed after JOIN keyword. Overrides CBO.

Advertisement

How it works

Overuse defeats CBO. Use sparingly for known cases.

Advertisement

Trade-offs + gotchas

Optimizer gets it wrong. Skew handling.