Rebuild An Index Costs Twice

Today has failed the rebuild of an index with ORA-01652 error. The point is to rebuild an index is more expensive in space that delete and recreate it. A reconstruction maintains the old index while creating the new. If we have an index that holds 20 gigabytes and rebuild, we will have in time given two indexes of 20 gigabytes each. If you delete and rebuild have only 20 gigabytes, of course, you need between 1.5 and 2.5 of size the index temporarily while it is rebuilding.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s