| Materialized views in 10g [message #104518] |
Tue, 09 November 2004 04:00 |
Alexei Ustyuzhaninov
Messages: 1
Registered: November 2004
|
Junior Member |
|
|
Could somebody explain the difference between between two features in oracle database 10g?
Citing http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=271886.1&p_showHeader=1&p_showHelp=1:
1. Summary management.
Summary management consists of mechanisms to define materialized views and dimensions, refresh and query rewrite mechanisms, and a collection of materialized view analysis andadvisory functions and procedures in the DBMS_OLAP package.
2. Materialized views.
Includes summary management functionality, join indexes, multi-tier materialized views, and summary advisor. Automatically redirects queries to stored summary tables, improving query performance dramatically.
They seem to be very similiar and their descriptions even refer to each other, but "Summary managemet" presents in Enterprise Edition only and "Materialized Views" are included in all editions.
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
