Answer Detail: RE: what are the difference between view and materiali...

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: what are the difference between view and materialized view?

October 10, 2005 23:22:33	#3
ravikumar guturi	Member Since: Visitor Total Comments: N/A
RE: what are the difference between view and materiali...
view is a tailraid representation of data, but metereialized view is stores precaluculated data, view is a logical structure but mview is physical structure, view is cant occupie the space bu mview is occpies space.