What is Materialized views? Explain its uses.In general, a view represents a queries result set. When this query result is cached and updated from the base table’s periodically, it is called as a materialized view. It is most commonly used in scenarios where frequent query data needs to be accessed. Unlike a view, materialized view is not virtual. It is typically used in data warehousing. Using materialized view network load is reduced.Why use materialized view instead of a table?Materialized views are basically used to increase query performance since it contains results of a query. They should be used for reporting instead of a table for a faster execution.
|
50 Oracle 11g dba Interview Questions and Answers - Freshers, ExperiencedOracle 11g dba interview questions and answers for both freshers and experienced - DBMS Introduction, ORACLE ARCHITECTURE, ORACLE Installation, Oracle Environment Variables, Managing physical structures (control files, data files, redo log files), Backup and Recovery, RMAN, Performance Tuning, Data Guard.