Answer Detail: RE: What is the difference between view and materializ...

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: What is the difference between view and materialized view

July 07, 2006 02:26:34	#4
vijay	Member Since: Visitor Total Comments: N/A
RE: What is the difference between view and materializ...
View is a logical reference to a database table. But Meterial View is actual table and we can refresh data in time intervels. If you made any change in database table that change will effect into view but not meterialize view..