Revision as of 20:50, 14 December 2017 edit Mindmatrix (talk \| contribs) Autopatrolled, Administrators 188,529 edits undo latent vandalism ← Previous edit		Revision as of 02:42, 15 December 2017 edit undo 2602:306:3823:52c0:b13c:58aa:d8bc:54 (talk) →Materialized views Next edit →
Line 23: Various [[database management system]]s have extended the views from read-only subsets of [[data]], particularly [[materialized view]]s: pre-executed, non-virtual views commonly used in [[Data warehouse\|data warehousing]]. They give a static snapshot of the data and may include data from remote sources. The accuracy of a materialized view depends on the frequency of trigger mechanisms behind its updates. Materialized views were introduced by [[Oracle Database]], while [[IBM DB2]] provides so-called "materialized query tables" (MQTs) for the same purpose. [[Microsoft SQL Server]] introduced in its 2000 version indexed views which only store a separate index from the table, but not the entire data. [[PostgreSQL]] implemented materialized views in its 9.3 release. Buckle your seat-belt! for [[Microsoft SQL Server]] == Equivalence ==

View (SQL): Difference between revisions