What is the difference between view and materialized view in Oracle?

1-In view Quer result is not stored in the disk or database but MV allow to store query result in the disk or table. 2-When we create view using any table rowid of view is same as original table but in case of MV rowid is different. 3-View are always get latest data but in case of MV we need to referesh the view for getting latest data. 4-Performance of view is less than MV. 5-In case of MV we need extra trigger or some automatic method so that we can keep MV refresh thtat is not required in View .

RAHUL SHUKLA11y

i Have a Doubt.Why On The Fly Table Used for? we can Use On The Fly Table to keep a Physical Copy of Table.

Adhikari Prachi Ranjan Das12y

A view is nothing but a SQL query takes the output of a query and makes it appear like a virtual table which does not take up any storage space or contain any data

But Materialized views are schema objects it storing the results of a query in a separate schema object (i.e. take up storage space and contain data). This indicates the materialized view is returning a physically separate copy of the table data.

Sapna Malik15y

What is the difference between view and materialized view in Oracle?

4 Answers