Answer Posted / nishi
Snapshots and Materialized view are used interchangeably as both are almost same. However, materialized view is having additional feature of query rewrite which is not in snapshot.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are a cluster and non-cluster index?
What is the use of oracle?
What are the ansi data types supported in oracle?
How can we delete duplicate rows in a table?
How oracle handles dead locks?
What is a relational database management system?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What privilege is needed for a user to query tables in another schema?
How to rename a tablespace in oracle?
How to save query output to a local file?
What the is the diff between local index and global index. give some example.
How does Oracle guarantee data integrity of data changes?
Can we insert data in view oracle?
How to turn on or off recycle bin for the instance?