February 13, 2013 at 4:30 am
Hi 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 help
As per my understanding indexed view is a subset of the table data with an index to get more performance.
February 13, 2013 at 4:36 am
Correct, 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.
February 13, 2013 at 5:04 am
Thanks Anthony.
They want real time data..Any way??
February 13, 2013 at 5:09 am
So 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.
February 14, 2013 at 4:47 am
Ratheesh.K.Nair (2/13/2013)
Thanks Anthony.They want real time data..Any way??
Wait, they want real time static data? That doesn't make any sense.
"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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply