October 23, 2012 at 12:56 am
Hi all,
where sql server indexed view data is stored.
for example in oracle materialized view, whenever we create materialized view one table will be created with mv name there the select statement data is stored.
like that where the indexed view data is stored in sql server...
thanks and regards
Sathiyan
October 23, 2012 at 5:37 am
A materialized view in SQL Server is a clustered index. This means that the data that defines the view will be stored within the view at the leaf level of the b-tree that defines the clustered index.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2012 at 5:41 am
After a unique clustered index is created on the view, the view's result set is materialized immediately and persisted in physical storage in the database, saving the overhead of performing this costly operation at execution time.
You can check the link below for your answers
http://msdn.microsoft.com/en-us/library/dd171921%28v=sql.100%29.aspx
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply