Technical Discussion :: Informatica
7 / 94
Oracle question: Difference in view and materialized views? Have you used views or synonyms?
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 ::
23 Feb, 2019 5:07 AM