DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2001
    Why do you have to rebuild indexes after a massive delete operation? Do you have to rebuild them to change the storage parameter ? Or just issue ALTER INDEX INDEX_NAME REBUILD

  2. #2
    Join Date
    Apr 2000
    Edison, NJ
    Deletes cause fragmentation within the index (also at the table level). Since indexes are used to aid in faster access to the data, it needs to be rebuilt. You can change the storage parameters of the index upon rebuilding it, or leave them the way they are just by using the comand: alter index index_name rebuild;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.