Abstract
Materialized view (MV) technology was introduced in Oracle Database version 7. This feature was originally called snapshots, and you can still see this nomenclature reflected in some data-dictionary structures. A materialized view allows you to execute a SQL query at a point in time and store the result set in a table (either locally or in a remote database). After the MV is initially populated, at some later point in time you can re-run the MV query and store the fresh results in the underlying table. There are two main uses for materialized views:
-
Replicating of data to offload query workloads to separate reporting databases
-
Improving performance of queries by periodically computing and storing the results of complex aggregations of data, which lets users query point-in-time results (of the complex queries)
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2010 Darl Kuhn
About this chapter
Cite this chapter
Kuhn, D. (2010). Chapter 15 Materialized Views. In: Pro Oracle Database 11g Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-2971-1_15
Download citation
DOI: https://doi.org/10.1007/978-1-4302-2971-1_15
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-2970-4
Online ISBN: 978-1-4302-2971-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)