Post reply

Inculude column index

  • April 28, 2012 at 2:07 am

    #260624

    I have a table and it have a lot of inculude column in the one index. In the Insert, Update, Delete operations inculude columns

    is efect the performance up or down

  • April 28, 2012 at 2:29 am

    #1480817

    Included columns improve the performance of Select queries. But, having too many Included columns decreases the performance of Insert, Update, or Delete operations to the underlying table or indexed view because of increased index maintenance.

    This will help you:

    Indexes with Included Columns

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • April 28, 2012 at 3:45 am

    #1480827

    ESAT ERKEC (4/28/2012)

    I have a table and it have a lot of inculude column in the one index. In the Insert, Update, Delete operations inculude columns

    is efect the performance up or down

    Any additional columns in an index have an IO impact on data modification querys as the engine has two update both the table and index where changes occur. Having included columns does reduce the potential impact as those columns are not sorted

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

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