| February 02, 2008 21:30:43 |
#1 |
| Jaycognos |
Member Since: November 2007 Total Comments: 13 |
RE: What is the difference between aggregate table and materliazed view?
|
| Aggregate tables are pre-computed totals in the form of hierarchical mutidimensional structure.,whereas materliazed view ,is an database object which caches the query result in a concrete table and updates it from the original database table from time to time .Aggregate tables are used to speed up the query computing whereas materialized view speed up the data retrieval . |
| |
