Why use materialized view instead of a table?

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.
Why and how the deadlock situation arises.
Why and how the deadlock situation arises? - A deadlock situation arises when two or more users wait for the same resource locked by one anther.....
50 Oracle 11g dba Interview Questions and Answers - Freshers, Experienced
Oracle 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.
What is large object in oracle? Explain its purposes
Large objects (LOB’s) are exclusively used to hold large amounts of data. It can hold data in tetra bytes.......
Post your comment