Post reply

Indexed View

  • February 13, 2013 at 4:30 am

    #274122

    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

    #1587355

    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

    #1587373

    Thanks Anthony.

    They want real time data..Any way??

  • February 13, 2013 at 5:09 am

    #1587377

    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

    #1587845

    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