Home Forums SQL Server 2005 Administering is it required to run reindex on a table soon after a column is dropped or added?if yes then why? RE: is it required to run reindex on a table soon after a column is dropped or added?if yes then why?

  • September 16, 2012 at 3:54 pm

    #1538360

    Thank you joy smith.that article explains lot but i am still bit confused.i understood why we need to rebuild whenever we drop a column.it is beacuse we have to

    free up the space used by dropped col but i donot understand why we need to rebuild index when a new col is added.could you please clarify?