Answer Posted / 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 data manipulation language?

1225

---

Does pdo prevent sql injection?

987

---

How do you write a subquery?

1064

---

Is sqlite free?

1020

---

can sql servers linked to other servers like oracle? : Sql dba

1047

---

Can we use ddl commands in pl sql?

1223

---

What found sql?

991

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1159

---

Which are the different case manipulation functions in sql?

1072

---

Difference between global and parameter variables?

2009

---

How many postgresql users are there, worldwide?

1125

---

What is dense_rank in sql?

1034

---

What are different types of sql?

1256

---

How many types of relationship are there?

1080

---

How do you truncate?

950

---