[sadiq31279]

What is the purpose of rebuilding an Oracle Index. What happen when an index is rebuild & how to do it.

[billm]

Try google "rebuild oracle index". There is lots of good material about it. Too detailed to go into here.

<http://www.google.com/search?hl=en&i...d+oracle+index>

[Orca777]

Originally posted by sadiq31279
What is the purpose of rebuilding an Oracle Index. What happen when an index is rebuild & how to do it.

If record are deletetd then index-blocks/structure get mor and more empty and will probably not refilled if the index key is a growing id.

So your index-segment grows and oracle needs to read a lot of more blocks to get the right key, because there is air in the index-blocks.

So you can rebuild them.
another reason is simply to change the tablespace and or the storage.
Orca