Databases Reference
In-Depth Information
Figure 5-10:
The optimization process.
As we've touched upon previously, the Query Optimizer has to find the best plan possible
within the shortest amount of time. More to the point, it must eventually return a plan,
even if that plan is not as efficient as it would like. To that end, the optimization process
also includes the concept of a timeout value. This timeout is not a fixed amount of time,
but is, instead, calculated based on the number of transformations applied together with
the elapsed time.
