Post reply

Advice needed with table update has poor performance because of view

  • May 23, 2012 at 3:49 am

    #261890

    Hi all,

    we have a situation where we update a table which is used in two views.

    Both views uses a table which contains about 10 million records (and is growing daily).

    We did already everything possible to enhance performance with indexes but still the performance is low.

    I am searching for advice what good approaches are in this kind of situation.

    One approach I am thinking of is using table partitioning on the huge table. But I am interested in other ideas.

    Any advice is very welcome.

    Thanks in advance,

    Perry van der Meeren

  • May 23, 2012 at 3:53 am

    #1491642

    perry - could you post the update command you are trying to perform, and also the structure of the table and all indexes on it.

    we can't really assist without this

    MVDBA

  • May 23, 2012 at 4:01 am

    #1491645

    A simple view won't cause an update to the table to be slow. If the view is indexed, maybe.

    Can you post the code and execution plan of the update.

    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

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

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