Wednesday, January 11, 2012
Thursday, January 5, 2012
Materialized Views
I have learned about a new concept about Database Tables: Materialized
Views which will be very useful in reporting purpose. This will help to decrease the processing time drastically thus improving the performance.
A materialized view is a database object that contains the
results of a query. They are local copies of data located remotely, or are used
to create summary tables based on aggregations of a table's data. (This is known
as Snapshots previously). Materialized Views will be updated immediately the
base table is updated or we can opt to deferred
to indicate to be populated every refresh
operation of database.
Refer to the below links for more details: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6002.htm#i2106785
Subscribe to:
Posts (Atom)