Flashcard

Pre-aggregate before joining fan-out tables

Aggregating in a subquery before joining prevents row multiplication from inflating your metrics.

Question

When joining a table to two child tables, why pre-aggregate before the join?

Click to reveal answer