Answer / guru

View: View is a virtual table, a query attached to it.
Actually it have not Stored query results. It will execute
and returns rows.

A materialized view is a database object that contains the
results of a query. They are local copies of data located
remotely, or are used to create summary tables based on
aggregations of a table's data. Materialized views, which
store data based on remote tables are also, know as
snapshots.A materialized view can query tables, views, and
other materialized views. Collectively these are called
master tables (a replication term) or detail tables (a data
warehouse term)

Answer / rahul khanke

views : this are the vertiual table.. views dosent stores
the data.. if we update the table then updation is in
actual table..
M view : this are the tables based on one or more tables..
this stores the data.. updation is done then actual
updation is in M. view itself..

Answer / a.jyothsna

VIEWS: Takes the output of a query
M.VIEWS: Stores the output of a query,Views can't store
the results of a query

Answer / pinkey

A view is just a stored query and has no physical part.
Once a view is instantiated, performance can be quite good,
until it is aged out of the cache. A materialized view has
a physical table associated with it; it doesn't have to
resolve the query each time it is queried. Depending on how
large a result set and how complex the query, a
materialized view should perform better.

Answer / naresh

View: - it is logical table,it doesn't contain any data,it's contain only select statement.
if you modify the data in view,it's immediately effect to the Base table.
it gets rowids same as the base table.
Materialized view: - M.V are mostly use in Data Marts.

What is before and after trigger?

0 Answers  

Does postgresql run on the cloud?

0 Answers  

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

Explain the components of sql?

0 Answers  

what is difference between delete and truncate commands? : Sql dba

0 Answers  

What is difference between inner join and self join?

0 Answers  

Is sql dba a good career? : SQL DBA

0 Answers  

What is a temporal data type?

0 Answers  

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

How many columns should be in an index?

0 Answers  

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

0 Answers