O'Reilly logo

Pro Oracle SQL by Jared Still, Riyaj Shamsudeen, Robyn Sands, Kerry Osborne, Karen Morton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. SQL Execution Plans

Karen Morton

You've seen quite a few execution plans in the first chapters of this book, but in this chapter I'm going to go into detail about how to produce and read plans correctly. I've built the foundation of knowledge you need to understand the most common operations you'll see used in execution plans, but you need to put that knowledge into practice.

By the end of this chapter, I want you to feel confident that you can break down even the most complex execution plan and understand how any SQL statement you write is being executed. With the prevalence of development tools such as SQL Developer, SQL Navigator, and TOAD (just to name a few), that can produce explain plan output, it is fairly easy to generate explain ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required