Even if the individual dimensions themselves are relatively small, the Cartesian join grows exponentially with each addition of a dimension.
即使单个维度相对较小,随着每个维度的加入,笛卡尔连接也会成倍增长。
The Cartesian join is reduced by the filters found in the join expressions from each dimension to the fake fact.
由于伪事实的每个维度中的连接表达式的过滤,笛卡尔连接结果缩小了。
If the Framework Manager model does not apply a form of filtering on the dimension query subjects, large Cartesian joins may be attempted.
如果FrameworkManager模型没有在维度查询主题上应用过滤,可尝试大型笛卡尔积可能出现。
Large dimension tables can produce resource intensive Cartesian joins.
大型维度表可能产生资源密集的Cartesian连接。
For example 10,000 rows in one dimension multiplied by 10,000 rows in another would produce a Cartesian join of 100,000,000 rows.
例如,一个维度中10,000行乘以另一个维度的10,000行会产生100,000,000行的Cartesian连接。
For example 10,000 rows in one dimension multiplied by 10,000 rows in another would produce a Cartesian join of 100,000,000 rows.
例如,一个维度中10,000行乘以另一个维度的10,000行会产生100,000,000行的Cartesian连接。
应用推荐