# View transformations

When Derby evaluates a statement that references a view, it transforms the reference to a view into a derived table. It might make additional transformations to improve performance.

- View flattening
  When evaluating a statement that references a view, Derby internally transforms a view into a derived table. This derived table might also be a candidate for flattening into the outer query block.
- Predicates pushed into views or derived tables
  An SQL statement that references a view can also include a predicate.

Parent topic: Internal language transformations
Related concepts
Predicate transformations
Transitive closure
Subquery processing and transformations
Outer join transformations
Sort avoidance
Aggregate processing