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
- 14184 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
Explain constraining triggers.
How many anonymous blocks can be defined?
What is max rowid in oracle?
Can a formula column referred to columns in higher group ?
What is a view and how is it different from a table?
What is meant by an index?
How would you begin to troubleshoot an ORA-3113 error?
Why use resource manager in Oracle?
How to connect to a remote server?
How to calculate date and time differences in oracle?
How to update values on multiple rows in oracle?
How to start a specific oracle instance?
Difference between pre-select and pre-query
What is dynamic proxy?
What is the usage of control file in oracle?
