Advertisement

Pro Oracle SQL pp 261-298 | Cite as

Subquery Factoring

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

Abstract

You may not be familiar with the term subquery factoring. Prior to the release of Oracle 11gR2, the official Oracle documentation barely mentions it, providing just a brief synopsis of its use, a couple of restrictions, and a single example. If I instead refer to the WITH clause of the SELECT statement, you probably know immediately what I mean, because these terms are more recognizable. Both terms are used in this chapter.

Keywords

Leaf Node Recursive Call Execution Plan Temporary Table Search Depth 
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