
308 10.4 Performance and the MODEL Clause
Figure 10.27 shows a very slight timing difference between using
UPSERT and UPDATE options. However, the difference in execution time
is so small as to probably be negligible.
10.3.5 Loops
The MODEL clause can even use for loops to scroll through sets of rows
and create multiple-dimensional cross-tabulations of all cells in a query.
The example in Figure 10.28 shows 2003 and 2004 figures summed into
2005, for all countries. The MODEL clause is extremely versatile and can
become highly complex.
10.4 Performance and the MODEL Clause
Even though use of the MODEL clause is a performance method in itself,
there are, ...