In data warehouse environments, it is common to use materialized views to speed up the performance of commonly used queries. A materialized view is simply a pre-built query that stores the results of the query in a table. With the query rewrite capability enabled, Oracle can automatically make use of materialized views without the user even knowing.Let’s take a look at a simple order table for a generic store along with a denormalized table for dates in the order system and some sample data:

Comment