InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 13:17:17 GMT20http://www.sqlservercentral.com/Forums/Topic1419386-1550-1.aspx[quote][b]Ratheesh.K.Nair (2/13/2013)[/b][hr]Thanks Anthony.They want real time data..Any way??[/quote]Wait, they want real time static data? That doesn't make any sense.Thu, 14 Feb 2013 04:47:54 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1419386-1550-1.aspxSo why the need to keep the data intact? If they want it real time they are going to have data fluctuation as values will always be changing.Wed, 13 Feb 2013 05:09:14 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1419386-1550-1.aspxThanks Anthony.They want real time data..Any way??Wed, 13 Feb 2013 05:04:45 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1419386-1550-1.aspxCorrect, it is just meta data which looks at the underlying tables.So if the data needs to be static, then you need to export the data to a different table(s) and change the view accordingly.Wed, 13 Feb 2013 04:36:22 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1419386-1550-1.aspxHi Experts,We have an indexed view and the development team want to keep the data in indexed view intact even if the data in base table is changed.Please helpAs per my understanding indexed view is a subset of the table data with an index to get more performance.Wed, 13 Feb 2013 04:30:28 GMTRatheesh.K.Nair