Heuristical Processing Strategies for Query Optimization

• Perform selection as early as possible

• Combine Cartesian product with a subsequent selection operation

• rearrange operations so that most restrictive selections are execued first

• Perform project as early as possible

• compute common expressions once(pipeline)

• Implemented into Rule based system : Table 23(21).4 (Oracle)