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 can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  

---

Can I learn sql in a week?

0 Answers  

---

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---

Why do we use joins?

0 Answers  

---

What is sql query limit?

0 Answers  

---

What is error ora-01000: maximum open cursors exceeded

0 Answers  

---

What are all the different normalization?

0 Answers  

---

What is coalesce in sql?

0 Answers  

---

What is native sql query?

0 Answers  

---

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

---