209 Views and materialized views

 209  Views and materialized views

 are both database objects that provide access to data, but they differ in several ways: 

• Storage

       - Views are virtual and don't store use memory or disk
  , while
       - Materialized views store precomputed data as a physical table. 
• Performance

       - Views are more efficient because they don't require storage or updates,
       - but materialized views can be faster for complex queries and aggregations