apache > db
Apache DB Project
Font size:      

Transitive Closure

Transitive Closure

The transitive property of numbers states that if A = B and B = C, then A = C.

Derby applies this property to query predicates to add additional predicates to the query in order to give the optimizer more information. This process is called transitive closure. There are two types of transitive closure:

  • transitive closure on join clauses

    Applied first, if applicable

  • transitive closure on search clauses

Previous Page
Next Page
Table of Contents