ZZJOIN operator

This operator represents a zigzag join.

Operator name: ZZJOIN

Represents: A zigzag join, which 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.

Performance suggestions:
  • If statistics are not current, update them using the RUNSTATS command.