Advertisement

Pro Oracle SQL pp 153-190 | Cite as

SQL Execution Plans

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

Abstract

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.

Keywords

Plan Operation Table Function Execution Statistic Execution Order Plan Output 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, and Jared Still 2010

Authors and Affiliations

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

There are no affiliations available

Personalised recommendations