What is Materialized View? In What Scenario we Use
Materialized View?
Answer Posted / 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 View All Answers
Can we alter stored procedure?
how to fetch alternate records from a table? : Sql dba
What is record data type?
Can we rollback after truncate?
Difference between global and parameter variables?
What trigger means?
What is the difference between a procedure and a function?
Is coalesce faster than isnull?
How to get unique records from a table?
What is scalar function in sql?
What is the difference between unique and primary key constraints?
What does select count (*) mean in sql?
What is the purpose of the partition table?
Is sqlite good enough for production?
What are the most important characteristics of pl/sql?