REBUILD INDEX AFTER DELETE

[panjub_raj]

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

[Halo]

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;