Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14651 Views
- I also Faced
- E-Mail Answers
Answer Posted / bhabna
1.Basically Materialize view is used as the local copy of a
remote table.So instead of using a remote table,we use M-
View to avoid the network trafic.
2. One of the most prominent feature of M-view is "ENABLE
QUERY REWRITE" clause.It is a query optimization
technique that transforms a user query written in terms of
tables and views, to execute faster by fetching data from
materialized views. It is completely transparent to the end
user, requiring no intervention or hints in the SQL
application because the Oracle9i server will automatically
rewrite any appropriate SQL application to use the
materialized views.
Where as view doesn't contain any such type of clause
3.View doesn't contains any data where as M-View does
4.View reflects the data whenever thae base table is
updated but M-view doesn't reflect that untill it is
refreshed.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why is sorter an active transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Enlist the tasks for which source qualifier transformation is used.
What are the differences between oltp and olap?
According to his methodology what all you need before you build a datawarehouse
What is a rank transform?
In development project what is the process to follow for an etl developer from day1
Performance tuning( what you did in performance tuning)
How to generate sequence numbers using expression transformation?
list out all the transformations which use cache?
Explain the difference between mapping parameter and mapping variable?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are active transformations.
