Post reply

Adding an Index increased Logical read

  • May 10, 2017 at 3:54 am

    #325574

    I have added a new index which is having key column is primary key and another column as included column , Now the query is using seek on that newly created index by logical read on that table increased from 728 to 3087

    Is this good ? or is it better to avoid  the new index?

  • May 10, 2017 at 4:10 am

    #1941946

    Rechana Rajan - Wednesday, May 10, 2017 3:54 AM

    I have added a new index which is having key column is primary key and another column as included column , Now the query is using seek on that newly created index by logical read on that table increased from 728 to 3087

    Is this good ? or is it better to avoid  the new index?

    Doesn't sound right, can you provide more information such as the table and index ddl, the query and the actual execution plan please?
    😎

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

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