Database Reference
In-Depth Information
Figure 12-3.
Log activity when a temporary table has not been cached
As you see, the first stored procedure call produced 50 log records. Forty of them (the highlighted portion) related
to the update of the allocation map pages and system tables during temporary table creation.
If you run the code from Listing 12-9 a second time, you will see a different picture, as shown in Figure
12-4
.
Figure 12-4.
Log activity when the temporary table has been cached
