Key points covered are
- Discover how to use several variations of the OPT_ESTIMATE hint to correct Oracle cardinality misestimates in a wide variety of situations and make SQL tuning a breeze!
- Find out about obstacles to Oracle’s CBO such as data skew, wild cards, and outliers, along with how they affect assumptions that the CBO makes about our queries.
- Uncover the shocking truth about a specific type of problem that has NO DOCUMENTED FIXES. The *ONLY* way to fix this problem is through using the OPT_ESTIMATE() hint.