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.
CITATION STYLE
Heller, J. (2019). Write Large SQL Statements. In Pro Oracle SQL Development (pp. 309–325). Apress. https://doi.org/10.1007/978-1-4842-4517-0_12
Mendeley helps you to discover research relevant for your work.