next up previous
Next: Other Operations Up: Equivalence of Expressions Previous: Projection Operation

Natural Join Operation

  1. Another way to reduce the size of temporary results is to choose an optimal ordering of the join operations.
  2. Natural join is associative:


  3. Although these expressions are equivalent, the costs of computing them may differ.
  4. Natural join is commutative:


Osmar Zaiane
Sun Jul 26 17:45:14 PDT 1998