View (SQL): Difference between revisions

Revision as of 21:21, 10 February 2006

Revision as of 21:23, 10 February 2006

Line 11:

Various [[database management system]]s have extended the views from read-only subsets of [[data]].

The [[Oracle database]] introduced the concept of [[materialized view]]s, which are pre-executed, non-virtual views commonly used in data warehousing. They are a static snapshot of the data and may include data from remote sources. The accuracy of a materialized view depends on the frequency or trigger mechanisms behind its updates. The equivalent of this in Microsoft's [[Microsoft SQL Server]], introduced in the 2000 version, is an indexed view.

== See also ==