What is Materialized View? In What Scenario we Use
Materialized View?
Answer Posted / chandan kumar
The above answer is right till here....view is a virtual
table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also
same
like the view but it exist in rdbms.
We use the Materialized View in that Senerio when we have
large amount of database and we need to refresh that in a
time being.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How can we store rows in PL/SQL using array?
How does index help in query performance?
Do we need to create index on primary key?
Explain the advantages and disadvantages of stored procedure?
How long does it take to learn pl sql?
What is difference between stored procedures and application procedures?
Why do we use joins in sql?
What does the hierarchical profiler does?
Can a varchar be a primary key?
What is a function in oracle pl sql?
Explain unique key in sql.
What is the difference among union, minus and intersect?
Can we write dml inside a function in sql server?
What are different functions in sql?
How to make a copy values from one column to another in sql?