Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

view and mview Expand / Collapse
Author
Message
Posted Saturday, August 22, 2009 12:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 22, 2009 12:53 PM
Points: 3, Visits: 5
dear all,

plz give me deep information about differences between view and mview.

Thanks
Post #775593
Posted Saturday, August 22, 2009 2:29 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 12:14 PM
Points: 3,433, Visits: 14,423
Views are DML(data manipulation langauge) statements that moves columns from many tables for easy access of data while Materialized Views is Oracle implementation of Views that uses the UNION ALL operator which by ANSI SQL definition are not updateable but because it uses partition are actually updateable. The Microsoft implementation starts from SQL Server 2000 and are called Partitioned Views. Check the links below for details.

http://msdn.microsoft.com/en-us/library/ms190019.aspx

http://msdn.microsoft.com/en-us/library/ms187956.aspx





Kind regards,
Gift Peddie
Post #775605
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse