ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Materialized Views and snapshots

Materialized Views and snapshots

原创 Linux操作系统 作者:treesofthehill 时间:2012-07-10 13:52:17 0 删除 编辑

A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. Unlike an ordinary view, which does not take up any storage space or contain any data, a materialized view contains the rows resulting from a query against one or more base tables or views. A materialized view can be stored in the same database as its base table(s) or in a different database.

Materialized views stored in the same database as their master tables can improve query performance through query rewrites. For queries that involve aggregate data or joins, the optimizer can rewrite the query to access the precomputed results stored in a materialized view. Query rewrites are particularly useful in a data warehouse environment.

Another name for materialized view is snapshot. This term generally refers to a materialized view used for replicating data in a remote database. In SQL statements, the keywords SNAPSHOT and MATERIALIZED VIEW are synonymous.

详见http://docs.oracle.com/cd/A87860_01/doc/server.817/a76965/c01intro.htm#7490

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9537053/viewspace-735064/,如需转载,请注明出处,否则将追究法律责任。

下一篇: sqlnet.ora配置
请登录后发表评论 登录
全部评论

注册时间:2008-06-11

  • 博文量
    97
  • 访问量
    179893