Materialized View and View

[mepancha]

Hi,
I need to know the acutal difference between Views and Materialized view.

Thanks

[Orca777]

Hi,
i try to

* Views are stored SQL-Queries, but no view-data is stored.
* Mviews are stored SQL-Quries to local or far objects, the view-data is stored locally and refreshed by specific interval. Mviews are not new, they derived from snapshots.
Oracle uses Mviews for more, for example with query-rewrite to speed up aggragated data-access.

Orca

[pando]

views are stored SQL

mviews are physical tables, like snapshots need to get refreshed at certain time, full or incremental, they are also used by the optimizer to accomplish query rewrites