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
- 14332 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 a user account in oracle?
Explain the use of rows option in imp command.
How can we delete duplicate rows in a table?
Why does oracle 9i treat an empty string as null?
Explain what are synonyms used for?
What is the use of file param in imp command?
How to define and use table alias names in oracle?
Explain do view contain data?
How to put more than 1000 values into an oracle in clause?
How to rename a tablespace in oracle?
What is the difference between postgresql and oracle?
What are the logical operations?
When do you get a .pll extension in oracle?
How to define an explicit cursor in oracle?
How to define a record variable to store a table row?
