Home / Educational Content / Database & Technology / Deep Dive into SQL Tuning

Deep Dive into SQL Tuning

Presented at INSYNC 21

Session ID: 100160

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

You’ve reached the ultimate Oracle customer network—exclusively for Quest Corporate and Professional members.

Join Quest to unlock access to strategic content centers, event replays, exclusive programming, and expert insights—all designed to help Oracle users like you go further, faster.

Whether you're on JD Edwards, PeopleSoft, or Oracle Cloud, Quest connects you with a powerful peer network and Oracle experts so you can make smarter decisions, drive innovation, and get more from your investment.

Quest is where Oracle customers connect, learn, and lead with confidence. Ready to join them?

Deep Dive into SQL Tuning