What is Materialized View? In What Scenario we Use
Materialized View?

Answers were Sorted based on User's Feedback



What is Materialized View? In What Scenario we Use Materialized View?..

Answer / chandan kumar

The above answer is right till here....view is a virtual
table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also
same
like the view but it exist in rdbms.

We use the Materialized View in that Senerio when we have
large amount of database and we need to refresh that in a
time being.

Is This Answer Correct ?    6 Yes 0 No

What is Materialized View? In What Scenario we Use Materialized View?..

Answer / thanigesan.m

view is a virtual table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also same
like the view but it exist in rdbms.
we use materialized view
e.g if we r having a table with 4 columns
empno ename sal comm
33 xxxy 1000 234
we can create a materialized view as totalsal by sum that 2
columns....

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

How is data stored in sql?

0 Answers  


What's the procedure?

0 Answers  


What is flag in sql?

0 Answers  


Can we create index on primary key?

0 Answers  


How do you declare a user-defined exception?

0 Answers  






Can you inner join the same table?

0 Answers  


What type of database is sql?

0 Answers  


what is sql server agent? : Sql dba

0 Answers  


if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  


how to create a primary key with out creating an index?

9 Answers   TCS,


What does count (*) do in sql?

0 Answers  


why we use nocopy?

2 Answers   Polaris,


Categories