Abstract: Systems, methods, media, and other embodiments associated with dynamically ranging over a set of materialized views to determine whether to associate a materialized view with a query at execution time are described. One example system may include a materialized view creation time logic that is configured to identify a materialized view, to create a containment expression, and to relate the containment expression to the materialized view. The example system may also include an execution time logic that is configured to receive a query having a bind variable. The execution time logic may dynamically range over materialized views to determine whether to use a materialized view(s) to process the query having the bind variable.

Abstract: An approach for processing a query in a database system is disclosed. An original query is determined to be partially satisfied by a materialized view. The original query is transformed using a set operation (i.e., union and intersection) on the materialized view and either another materialized view or a base table.