Core concept
SELECT /*+ BROADCAST(dim) */ * FROM fact JOIN dim ON ...Advertisement
How it works
Overusing = don't leverage AQE. But essential when optimizer wrong.
Advertisement
Trade-offs + gotchas
Known-small tables. Skew handling.