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
what is the difference between nested subquery and correlated subquery?
Is clustered index a primary key?
Do we need to create index on primary key?
Is left join same as inner join?
What is the basic structure of an sql?
What is posting?
What is acid property in a database?
Is left join faster than inner join?
how many values can the set function of mysql take? : Sql dba
Can we join same table in sql?
What is clustered and nonclustered index in sql?
What are the different types of sql commands?
How to run pl sql program in mysql?
How are functions and procedures called in PL/SQL?
What is sql injection owasp?