- This event has passed.
Event Navigation
Speaker
Webinar
Speaker Profile
Kaley Crum is an Oracle Ace with over a decade of Oracle experience. He’s the author of the TuningSQL.com blog, and has spoken at several Oracle conferences across the United States.
Description of the Webinar
One of the most common SQL Tuning problems is when the Oracle cost-based optimizer misestimates the expected number of rows that will be returned from an execution plan row source operation. This presentation delves into uncharted waters for dealing with cardinality misestimates for making queries run faster.
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.