Database Reference
In-Depth Information
Figure 23-1.
Schema locks: Query compilation
If you run that example the second time, when queries are compiled and plans are in cache, you would see a
slightly different picture, as shown in Figure
23-2
.
Figure 23-2.
Schema locks: Query execution when plans are in cache