title: Should i disable clustered index before deleting data?
body: <p>i know this has been discussed already like anything but could not find a reliable answer i can go with.</p>
  
  <p>Suppose i have a table with 10 billion records and need to delete records with identity column in where clause. which option should i go with?</p>
  
  <p>option 1: disable the index which will save overhead to rearrange the index after deletion but will take longer time to search which row needs to deleted.</p>
  
  <p>option 2: will not do anything with index which will locate the row very fast but rearrange the index can take some time.</p>
  
  <p>i am more inclined towards the 2 option but want to see what will experts say? :)</p>