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 ...;

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

---

What is bitemporal narrowing?

0 Answers  

---

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---

What is primary key and foreign key?

0 Answers  

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

Difference between table function and pipelined function?

0 Answers  

---

What is query optimization in sql?

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

How do I view a sql trace file?

0 Answers  

---

what is single byte over head in oracle..?

0 Answers  

---

How does postgresql compare to "nosql"?

0 Answers  

---