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

What is snowflake sql?

1 Answers  

---

What is dynamic query?

1 Answers  

---

what does the t-sql command ident_incr does? : Transact sql

1 Answers  

---

Is trigger a stored procedure?

1 Answers  

---

Is inner join same as self join?

1 Answers  

---

How does index help in query performance?

1 Answers  

---

What does where 1/2 mean in sql?

1 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

What is pl/sql and what is it used for?

4 Answers  

---

Is crud a cuss word?

1 Answers  

---

Why do you partition data?

1 Answers  

---

Show the two pl/sql cursor exceptions.

1 Answers  

---