What is materialised View?

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between nested subquery and correlated subquery?

643


Is clustered index a primary key?

611


Do we need to create index on primary key?

556


Is left join same as inner join?

636


What is the basic structure of an sql?

661






What is posting?

685


What is acid property in a database?

671


Is left join faster than inner join?

732


how many values can the set function of mysql take? : Sql dba

634


Can we join same table in sql?

650


What is clustered and nonclustered index in sql?

588


What are the different types of sql commands?

688


How to run pl sql program in mysql?

594


How are functions and procedures called in PL/SQL?

689


What is sql injection owasp?

631