ZZJOIN (for DB2 for Linux, UNIX, and Windows, Version 10.1)

This operator represents a zigzag join.

A zigzag join joins a fact table and two or more dimension tables in a star schema. The columns joining dimension tables with the fact table must be unique. Queries that use an all-probes list-prefetch plan for the fact table access will include two separate ZZJOIN operators. One of those two ZZJOIN operators represents a back-join between the fact table and the dimension tables.