Advertisement

Pro Oracle SQL pp 131-167 | Cite as

SQL Execution Plans

  • Karen Morton
  • Kerry Osborne
  • Robyn Sands
  • Riyaj Shamsudeen
  • Jared Still
Chapter

Abstract

You’ve seen quite a few execution plans in the first chapters of this book, but in this chapter I 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 now you need to put this knowledge into practice.

Keywords

Nest Loop Plan Operation Execution Order Plan Output Bind Variable 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Karen Morton 2013

Authors and Affiliations

  • Karen Morton
    • 1
  • Kerry Osborne
    • 1
  • Robyn Sands
    • 1
  • Riyaj Shamsudeen
    • 1
  • Jared Still
    • 1
  1. 1.FLUS

Personalised recommendations