Presented at Database & Technology Week 2021
Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals. Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.
Watch the full-length video
Access our complete catalog of webinars, blogs and customer stories. Leverage insight from across the community through our library of 4,000+ educational resources.