| November 11, 2005 13:49:03 |
#8 |
| kalavlag |
Member Since: Visitor Total Comments: N/A |
RE: what are the difference between view and materiali...
|
| A view is just a stored query and has no physical part. Once a view is instantiated, performance can be quite good, until it is aged out of the cache. A materialized view has a physical table associated with it; it doesn't have to resolve the query each time it is queried. Depending on how large a result set and how complex the query, a materialized view should perform better. |
| |
