page81
63
Figure 3-11.
Sample query profile for dynamic table
Now that you have an understanding of what a query profile looks like and the
relationship to how the query is parsed, let’s investigate how to optimize the query
profiles.
A Good Query Profile
In this section, you must first understand what a “good” query profile looks like and
explain why a query profile is considered “good.” You then demonstrate what a “bad”
query profile looks like and demonstrate how to identify what constitutes “bad.”
Snowflake optimizer join order heuristics are optimized for star schemas.
You begin by referencing the now familiar first query profile as this is a “good”
example.
ChapTer 3
The Query profiler