what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots?
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 lookup table in oracle?
How to assign query results to variables?
How to manage transaction isolation level?
How do we display rows from the table without duplicates?
How to find the duplicate rows count from employees table in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is the maximum limit on the number of columns in a table?
What is the parameter mode that can be passed to a procedure?
Explain an integrity constrains?
Is there any function in oracle similar like group_concat of mysql?
What are the different oracle database objects?
How to pass parameters to procedures?
Explain what are the type of synonyms?
How to get execution path reports on query statements?
What is MTTR advisor in Oracle?