In this step, the tree is mapped onto equivalent trees by using a set of formal rules inherited from relational algebra

The trees are numbered based on the heuristics to filter candidates that are obviously no recommended. The general rule in this case is "move the nonspatial operators SELECT and PROJECT down in the tree". For each alternative is possible to define the rank

Rank = selectivity - 1 / differential cost
selectivity(p): cardinality (output(p)) / cardinality (input(p))

The space of alternatives is generated with rules of relational algebra based on notions of commutativity, associativity and distributivity

Última modificación: Thursday, 24 de November de 2005, 15:08