Combining three or more dimensions in a query without fact data, can also cause large Cartesian joins.
在一个查询中不带事实数据连接三个或更多维度,也能产生大型笛卡尔连接。
Even if the individual dimensions themselves are relatively small, the Cartesian join grows exponentially with each addition of a dimension.
即使单个维度相对较小,随着每个维度的加入,笛卡尔连接也会成倍增长。
The net result of the fake fact query subject will be to create a Cartesian Product for the dimensions, which returns in a shorter period of time.
伪事实查询主题的第二个作用是创建维度的笛卡尔积,它能缩短时间。
应用推荐