• Cite Icon3
  • https://doi.org/10.1007/978-1-4842-4517-0_12Copy DOI Icon

Write Large SQL Statements

  • Jan 1, 2019
  • Jon Heller
Show More
  • Abstract
  • Literature Map
  • Citations
  • Similar Papers
Abstract

We must write large SQL statements to take full advantage of the power of Oracle SQL. Large procedures are an anti-pattern in procedural programming languages; we need to understand why SQL is different. Large SQL statements create several risks and opportunities; we must be aware of the consequences of parsing, optimizer transformations, resource consumption, context switches, and parallelism. Finally, we need to learn how to read and debug large SQL statements.

Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.