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.
- If statistics are not current, update them using the RUNSTATS command.