qq_45756769的博客

原创 zigzag join

A zigzag join is a join method in which a fact table and two or more dimension tables in a star schema are joined, such that the fact table is accessed using an index. It requires equality predicates between each dimension table and the fact table. This jo