Databases Reference
In-Depth Information
Counter
Occurrence
Value
elapsed time
1
0.166
final cost
1
5.8466425
gain stage 0 to stage 1
1
0.351461336
gain stage 1 to stage 2
1
0.002873885
indexed views matched
1
1
maximum DOP
1
0
optimizations
1
1
search 0 tasks
1
681
search 0 time
1
0.016
search 1 tasks
1
4796
search 1 time
1
0.111
search 2
1
1
search 2 tasks
1
1623
search 2 time
1
0.02
tables
1
6
tasks
1
7100
Table 5-14:
Optimization information for search 2 phase.
The optimization information shows that this query went throughout all the three stages
of optimization (as show in Figure 5-10) and, among other things, also includes both of
the stage-to-stage gain counters described earlier.
