Answer / narenkumar reddy

Mv is database object it contain the data stored physically
from select stmt of query
first time it will get the data base table next time onwards
based on refresh methods mv are created tables and views and
also mv
there three types of refresh methods
1.complete(the whole query execute)
2.fast(only modified records are updated target table i.e
incremental loading)
3.force(some times means when we r using agg function on
that time fast option is not working so we go for force option)

Answer / dinesh

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table.

CREATE MATERIALIZED VIEW view-name
BUILD [IMMEDIATE | DEFERRED]
REFRESH [FAST | COMPLETE | FORCE ]
ON [COMMIT | DEMAND ]
[[ENABLE | DISABLE] QUERY REWRITE]
[ON PREBUILT TABLE]
AS
SELECT ...;

How to copy a table in another table with datas?

9 Answers  

---

In a table only one column how to update rows

5 Answers   Microsoft,

---

Why stored procedures are faster than query?

0 Answers  

---

what is sql? : Sql dba

0 Answers  

---

What is aggregate function in sql?

0 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

what is the use of set statement in tsql? : Transact sql

0 Answers  

---

Can a table contain multiple foreign key’s?

0 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

Explain locks? : Transact sql

0 Answers  

---

How many clustered indexes can you have?

0 Answers  

---

What is partition in sql query?

0 Answers  

---