page82
64
Knowing the Snowflake optimizer join order heuristics are optimized for star
schemas allows you to differentiate “good” from “bad” query profiles. Using the
familiar query profile, overlaid with new terminology “Build” and “Probe,” as shown in
Figure 3-12, is further explained next.
Figure 3-12.
Build, probe, and right deep tree
ChapTer 3
The Query profiler