Date: August 27, 2020

Time: 7:00 PM IST & 09:30 AM EST

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.