That's strange. While the cartesian product is not commutative (because of the order in which items appear in the final product), the cardinality of the result

That's strange. While the cartesian product is not commutative (because of the order in which items appear in the final product), the cardinality of the result result set should be independent of the order in which records are joined because the cardinality is obtained by multiplying the cardinality of each constituent set. https://en.wikipedia.org/wiki/Cartesian_product#Cardinality https://en.wikipedia.org/wiki/Cartesian_product#Cardinality