Reducing the complexity of complex queries by similarly handling sub-queries is known as multi query optimization.

The sequence of queries that reflect the typical workload on the system are known as workload.

The changes made to a relation or and expression are known as differentials in materialized view management.

If a query is optimized without providing specific values for its parameters the technique is called parametric query optimization.

The task of keeping a view up to date with the underlying data is called as view maintenance.

Shared scan optimization is a multi query optimization technique.

Incremental, immediate and deferred are all different types of materialized view management techniques. Most database systems perform immediate view management.

Modifying only the affected parts of the materialized view is called as incremental view maintenance. It is much more efficient than ordinary view management.

A view whose contents are computed and stored is called as a materialized view. I does not only store the query defining the view.

The problem of an update affecting the execution of a query associated with the update is known as the Halloween problem. This was because it was first recognized on the Halloween day at IBM.