Opening book details…
Can I read Creating Materialized Views in SQL on EtoBox?
Creating Materialized Views in SQL by Ziad Baloch is a document available to read on EtoBox.
What is Creating Materialized Views in SQL about?
1. CREATE MATERIALIZED VIEW is used to create a materialized view, which contains the results of a query and allows those results to be maintained on the local database. 2. Materialized views are useful for data warehousing and replication purposes. For replication, they allow copying of remote data locally. For data warehousing, they support query optimization. 3. The physical properties, storage characteristics, columns, partitioning, and refresh properties of a materialized view can be specified during
- Author
- Ziad Baloch
- Language
- EN