Post reply

disable versus drop index

  • November 10, 2005 at 10:04 am

    #167006

    I really don't see much difference between dropping and disabling an index apart from when using disable followed by rebuild you don't have to redefine the index.
     
    Both will physically remove the index. Right?

  • November 14, 2005 at 3:16 am

    #603601

    No, the index still exists, takes up space, it's just disabled. But you're right, the primary reason for using Disable is to simplify the process to a simple ALTER table command.

    Note that disabling a clustered index will mark the table as OFFLINE as well.

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

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