Deep Dive into SQL Tuning – Q&A throughout presentation
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.
1. What tools are available for deep diving into a SQL statement?
2. When would you use each of these tools, and how do you understand the output?
3. What are some of the ways to force the optimizer to behave the way I want it to?