Indexed View

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Indexed View

Indexed View

Rate Topic

Display Mode

Topic Options

Author

Message

Ratheesh.K.Nair

Posted Wednesday, February 13, 2013 4:30 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 2,415, Visits: 3,379

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.

Post #1419386

anthony.green

Posted Wednesday, February 13, 2013 4:36 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1419389

Ratheesh.K.Nair

Posted Wednesday, February 13, 2013 5:04 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 2,415, Visits: 3,379

Thanks Anthony.

They want real time data..Any way??

Post #1419412

anthony.green

Posted Wednesday, February 13, 2013 5:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1419417

Grant Fritchey

Posted Thursday, February 14, 2013 4:47 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 7:42 AM
Points: 13,382, Visits: 25,180

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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1419979

« Prev Topic | Next Topic »

Permissions