Post reply

will it update view

  • October 17, 2014 at 7:21 am

    #311943

    Hi,

    will it update view when ever underlying tables insert,update and delete records will have any performance issue.

    --chalam

  • October 17, 2014 at 7:24 am

    #1753146

    Views are just saved select statements. They have no data storage.

    When you query a view, all SQL does is query the tables that the view references to get the data that you want.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 17, 2014 at 7:45 am

    #1753156

    chalam87 (10/17/2014)

    will it update view when ever underlying tables insert,update and delete records will have any performance issue.

    Is it an indexed view?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply