page56
37
You then looked at how a query is executed and began to see just how complex
the query optimizer is. I also exposed some scenarios such as spills and parallelization
where tuning will help.
Having established baseline information in preparation for looking deeper into
performance tuning, I will cover query profiles in the next chapter.
Chapter 2
the Query Optimizer