page77
59
Figure 3-8.
Sample query with parsing order
You will now briefly investigate the creation and use of a dynamic table (previously
called materialized table), a new feature currently in public preview.
Materializing Your Example Query
You can replace the earlier example query with a dynamic table. The purpose of this
section is to offer an alternative performance tuning approach.
ChapTer 3
The Query profiler