ZZJOIN
Short Description
The ZZJOIN operator represents a zigzag join used on star schema
Detailed Description​
The ZZJOIN operator represents a zigzag join. A zigzag join joins a fact table with two or more dimension tables in a star schema. The dimension to fact join columns must be unique. More information about star schema and zigzag joins can be found here.
Additional Links​
- DB2 Docs - zigzag join access plan examples
- DB2 Docs - ZZJOIN
- DB2 Docs - Explain Concepts
- DB2 Docs - Access Plan Optimization
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.