Technical Discussion :: Informatica
Home > Technical Interview Q&A > Informatica > Discussion
7 / 94
Oracle question: Difference in view and materialized views? Have you used views or synonyms?
Answer:
3 types of views
Simple,complex, m view
M views are used to increase the performance, it is like snapshot of the table. Stores result of the query
Views are virtual table, logical set of one r more tables.
Asked In ::

HARIPRASAD
23 Feb, 2019 5:07 AM