About this document
Understanding Oracle Hints for Optimization by Ram Kumar is a document available to read on EtoBox.
Hints can be used to influence the Oracle optimizer to choose a better execution plan when table statistics, indexes, or histograms are not gathered properly. Hints should only be used as a last option if gathering statistics properly does not result in an optimal plan. There are different categories of hints, including some important common hints for access paths. Altering a table to be parallel can also help optimize query performance.
- Author
- Ram Kumar
- Language
- EN