Database Reference
In-Depth Information
You can see that the steps to optimize the costliest query make for a complex process, which also requires multiple
iterations to troubleshoot the performance issues within the query and apply one change at a time. Figure
1-2
shows
the steps involved in the optimization of the costliest query.
Figure 1-2.
Optimization of the costliest query