Interested to Buy Any Domain ? << Click Here >> for more details...
what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots?
- 2 Answers
- 14319 Views
- I also Faced
- E-Mail Answers
Answer Posted / mkumar.it
Snapshots and Materialized view are used interchangibly as
both are almost same. However, materialized view is having
additional feature of query rewrite which is not in snapsot.
In this feature, suppose you made any materialized view
using some aggrigate function and you query base table from
sql using same aggrigate funtion, the query will execute on
the materialized view instead of querying base table
provided you have query rewrite priviledge.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What is logical backup in oracle?
What is parameterized cursor in oracle?
What is redo log?
Difference between oracle's plus (+) notation and ansi join notation?
What happens in oracle commit?
why dont we assign not null constraint as table level constraint.
How many memory layers are in the oracle shared pool?
Why does for update in oracle 8 cause an ora-01002 error?
How to create id with auto_increment on oracle?
How would you begin to troubleshoot an ORA-3113 error?
What the is the diff between local index and global index. give some example.
What privilege is needed for a user to create indexes in oracle?
How to test null values?
What is the usage of synonyms?
How can we find out the current date and time in oracle?
