Summary

In this chapter, you saw how the Optimizer in Oracle Database 10g helps enhance overall performance by using innovative ways of making sure that the best execution paths are chosen. Along the way, you delved into details about the Optimizer including histograms, dynamic sampling, and SQL profiles. We discussed some tipsas well as potential trapsfor using the Optimizer in Oracle Database 10g.