The Cartesian join is reduced by the filters found in the join expressions from each dimension to the fake fact.
由于伪事实的每个维度中的连接表达式的过滤，笛卡尔连接结果缩小了。
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, write indexable or stage 1 predicates and avoid writing queries without join predicates (also known as Cartesian join).
例如，编写可索引或一阶谓词，尽量不要编写没有连接谓词（也称为Cartesian 连接）的查询。
Even if the individual dimensions themselves are relatively small, the Cartesian join grows exponentially with each addition of a dimension.
即使单个维度相对较小，随着每个维度的加入，笛卡尔连接也会成倍增长。
In a cross join, each row from one table is combined with each row from another table, resulting in what is called a cross product or a Cartesian product.
在交叉联接中，一个表中的每一行与另一个表中的每一行合并，导致生成叉积或卡迪尔积。
A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join.
一个没有WHERE子句的交叉联接，会产生所关联表的笛卡尔乘积。
A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join.
一个没有WHERE子句的交叉联接，会产生所关联表的笛卡尔乘积。
应用推荐