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
- 14422 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
How to define default values for formal parameters?
What is bulk load in oracle?
Name the three major set of files on disk that compose a database in Oracle?
why dont we assign not null constraint as table level constraint.
Is postgres faster than oracle?
What is blob datatype?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
what is meant by magic query
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to initialize variables with default values?
What are the different pseudo commands? Explain in general?
How to list all tables in your schema?
List out the types of joins.
What is the implicit cursor in oracle?
How to import one table back from a dump file?
