Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kawadeprasad
Starting Member
13 Posts |
 Posted - 2012-06-05 : 02:20:19
|
| Hi Guru'sCan I create a materialized view on a view? If so then will occupy any storage space? how?_ Prasad |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
|
|
kawadeprasad
Starting Member
13 Posts |
Posted - 2012-06-05 : 03:43:48
|
| Thanks. It was helpful. Though I do have a question.Materialized view may store results in some schema object unlike simple views. Now if create a materialized view (which stores results) unlike simple views (which does not store result but only generates result view); then in this case weather results will get stored in schema object.As per my understanding it should be though I would like to confirm. |
 |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-06-05 : 05:35:55
|
| Yes, the result set of the Indexed view is physically stored in the database.The clustered index is stored in SQL Server and updated like any other clustered index.N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
|
|
|
Materialized View