Post reply

Impact of creating a non clustered index

  • August 20, 2013 at 7:37 am

    #276297

    Hi Experts,

    Please let know the impact of creating a non-clustered index on a table having 10million records and columns included in index are of int datatype.

    Thanks in Advance

  • August 20, 2013 at 7:41 am

    #1643078

    Impact in what sense?

    It's going to take time, time in which the table will be locked. It will take space. It will add time to index maintenance. If you've done your analysis properly it will speed up the queries it was designed for. It may impact inserts, updates and deletes.

    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

  • August 20, 2013 at 8:26 am

    #1643094

    Thanks a lot Gail.

    As you mentioned I was worried about locking ,blocking or deadlock which may happen because of this and time duration. This one completed very quickly 2secs

    For clustered index i think the impact is going to huge as it will physically arrange the data .Please correct me if I am wrong.

    TIA

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

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