Post reply

Dropping NON Clustered Indexes

  • April 15, 2015 at 1:59 pm

    #104252

    We have a table with over a million rows and there is a primary key on the table.

    We have an additional non clustered index that indexes 3 columns.

    During the upload or inserting process, what would happen if I removed the non clustered index.

    What will happen to the current data and the data being inserted.

    I believe the data would still be as it is.

    Any guidance would be appreciated.

    Thanks

    Gary

  • April 15, 2015 at 10:31 pm

    #1791238

    Only the clustered index has anything to do with the actual data in the table. NCIs are their own ball of wax and won't affect any data.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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