3
- https://doi.org/10.1007/978-1-4842-4517-0_12
Write Large SQL Statements
- Jan 1, 2019
- Jon Heller
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.
- # Procedural Programming Languages
- # Context Switches
- # Resource Consumption
- # Read Statements
- # Procedural Languages
- # Large SQL
- # Oracle SQL
- # SQL Statements
- # Procedural Programming
- # Programming Languages