Drop index on a large table RRS feed

  • Question

  • Hi All,

    I have a table size approx 1 TB  and millions of records, where one  non-clustered index is there size 255 GB, i wanted to drop that index, its a table on production environment. 

    I believe drop index on a huge table will take time and it may also lock table? whether dropping index lock table ?

    should i disable index and then drop index ?

    SQL Server DBA

    Wednesday, June 26, 2019 11:16 AM


  • Both disabling index or dropping it would not be that easy, yes locks would be applied if index is used. Simply do it when load is relatively very less. or during downtime



    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles


    • Marked as answer by Zeal DBA Wednesday, June 26, 2019 11:45 AM
    Wednesday, June 26, 2019 11:21 AM