Interested to Buy Any Domain ? << Click Here >> for more details...
What is Materialized View? In What Scenario we Use
Materialized View?
- 2 Answers
- 9515 Views
- Dinesh, Marlabs, I also Faced
- E-Mail Answers
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 is hibernate and its relation to sql?
what are the differences between char and nchar? : Sql dba
What are the different dcl commands in sql?
Why use subqueries instead of joins?
What is having clause in sql?
what is the difference between $message and $$message? : Sql dba
Why use triggers in sql?
What are the advantages of normalization?
What is the difference between sql, mysql and sql server?
How do I send sql query results to excel?
What will you get by the cursor attribute sql%found?
What is memory optimized table?
How does sql profiler work?
Can we perform dml on view?
Why do we need a foreign key?
