What is Materialized View? In What Scenario we Use
Materialized View?
Answers were Sorted based on User's Feedback
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 |
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 |
How is data stored in sql?
What's the procedure?
What is flag in sql?
Can we create index on primary key?
How do you declare a user-defined exception?
Can you inner join the same table?
What type of database is sql?
what is sql server agent? : Sql dba
if a string is there like s1,s2,s3,s4.How to find count of commas in this.
how to create a primary key with out creating an index?
What does count (*) do in sql?
why we use nocopy?