Home Forums Article Discussions Article Discussions by Author Discuss content posted by David Durant Stairway to SQL Server Indexes: Step 12, Create Alter Drop RE: Stairway to SQL Server Indexes: Step 12, Create Alter Drop

  • February 23, 2012 at 9:13 am

    #1450945

    If the index is disabled, the metadata is still there. That's all that's needed to rebuild an index (rebuild actually creates an new index structure). If the index is actually deleted, then it can't be rebuild and would have to be completely recreated

    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