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
What problem one might face while writing log information to a data-base table in pl/sql?
What is the syntax to add a record to a table?
What is data profiling in sql?
How to check if a column is nullable before setting to nullable?
What are views in sql?
Write the alter statement to enable all the triggers on the t.students table.
what are the different index configurations a table can have? : Sql dba
What is right join sql?
Does mysql support pl sql?
What is the basic form of sql query?
how can we submit a form without a submit button? : Sql dba
Explain the working of foreign key?
What is difference between sql and excel?
What is scope and visibility in PL/SQL?
Explain the order of sql statement execution?