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
- 14279 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
Can we save images in a database and if yes, how?
Is it possible to insert comments into sql statements return in the data model editor ?
What is merge statement used for?
What is a connect identifier?
How to change system global area (sga) in oracle?
How to use existing values in update statements using oracle?
Difference between hot backup vs. Cold backup?
State all possible different index configurations a table can possibly have?
How to add a new column to an existing table in oracle?
can u plz provide me oca sql dumps please i need them
What are the different pseudo commands? Explain in general?
How to assign data of the deleted row to variables?
What is a schema in oracle?
How do you find current date and time in oracle?
Differentiate between function and procedure in oracle.
