-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|