Interested to Buy Any Domain ? << Click Here >> for more details...
What is Materialized View? In What Scenario we Use
Materialized View?
- 2 Answers
- 9393 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 are local and global variables and their differences? : Sql dba
Which are sql * plus commands?
How do I sort a table in sql?
Write an sql query to select all records from the table?
what is innodb? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Explain isolation levels. : Transact sql
What is scope and visibility in PL/SQL?
Why triggers are used?
Define tables and fields in a database
What is database sql?
Where can I learn sql for free?
what is the difference between where clause and having clause? : Sql dba
how many sql dml commands are supported by 'mysql'? : Sql dba
