REBUILD INDEX AFTER DELETE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: REBUILD INDEX AFTER DELETE

  1. #1
    Join Date
    Mar 2001
    Posts
    78
    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
    Location
    Edison, NJ
    Posts
    759
    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