Imapct on indexes if schema updated RRS feed

  • Question

  • Hi Team,

    I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the table with no issue to existing index ?


    Thursday, March 29, 2012 10:03 PM


  • No concersn for existing indexes when adding new columns.  However, for altering or dropping columns, you need to drop/disable indexes on those columns.

    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

    • Marked as answer by BI_Sal Thursday, March 29, 2012 11:28 PM
    Thursday, March 29, 2012 11:24 PM