How a table is different from materialized view?

Materialized view (MV) is for disconnected computing, the difference between table and MV is table you can do DML operations which will be seen by other users, whereas the changes you do to MV will not be available to others until you update your database server. MV has another advantage when you build MV based on multiple tables using complex queries, the users when using MV, the performance increases drastically.

Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.