Post reply

Adding Clustered index to table that has a non clustered index

  • June 12, 2012 at 2:56 am

    #262272

    Hi Experts ,

    I have a table which has non clustered index defined on the a column. Later i added a clustered index to another column.

    Will the nonclustered pages at the level be updated in this scenario, mapping to key columns in CI ?

    Please help me in understanding this

    Thanks

    Chiathanya M

  • June 12, 2012 at 3:28 am

    #1499666

    If you add a clustered index to a heap table, all nonclustered index get rebuilt to change the row locator from RID to clustering key.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • June 12, 2012 at 3:34 am

    #1499668

    chaithu559 (6/12/2012)

    Will the nonclustered pages at the level be updated in this scenario, mapping to key columns in CI ?

    Yes. You are right.

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

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