Distribution, commutation and association in database queries


Another reminder note. The RDBMS query engine relies on these laws to build efficient queries: Commutation: Numbers may travel (commute) or in relational algebra Association: Numbers may freely associate or in relational algebra Distribution: Operators can be distributed or, in relational algebra A more general statement of these laws: Commutative law: Associative law: Distributive law:… Read More Distribution, commutation and association in database queries