Glossary
Writing clear join conditions
ambiguous or overly complex ON clauses can confuse the optimizer.
Learn More
IBM DB2
—
Chapter 6: Joining Tables — INNER, OUTER, CROSS, and LATERAL
Related Terms
"DB2 for z/OS: Diagnosis Guide and Reference"
"db2pd — A Practical Guide"
"On Writing Well" by William Zinsser
"Optimizing DB2 Queries with IBM Data Studio"
"Oracle to DB2 Conversion Guide"
"Presenting to Win" by Jerry Weissman
"Sargable Predicates and Index Design"
"Self-Tuning Memory Manager: Under the Hood"