Differentiation between view and materialized view

Write down the differentiation between view and materialized view?

View Complete Question

Comments & Conversion

Expert

Verified

View:

Tail raid data representation is offered through a view to access data from its table.
It has logical structure can’t take up space.
Alters get influenced in corresponding tables.

Materialized view:

Pre computed data perseveres in materialized view.
It has physical data space activity.
Alters will not get influenced in corresponding tables.

Related Questions in Database Management System

Q : Surrogate key-primary key Describe a

Describe a surrogate key and also explain the ideal primary key and illustrate how surrogate keys meet up this ideal?

Q : Describe briefly the term ADO.NET

Describe briefly the term ADO.NET?

Q : Define Cloud Computing Cloud Computing

Cloud Computing – A computing capability that provides an abstraction between the computing resource and its underlying technical architecture (e.g., servers, storage, networks), allowing convenient, on-demand network access to a shared pool of