Database / SQL
Difference between view and materialized view in SQL.
Views are virtual and the query is executed every time it is accessed. The upside of a view is that it will always return the latest data to you. The downside of a view is that its performance depends on how good a select statement the view is based on. If the select statement used by the view joins many tables, or uses joins based on non-indexed columns, the view could perform poorly.
Materialized views are disk-based and are updated periodically based upon the query definition.
More Related questions...
