recreate indexes

[raghud]

Sorry Instead of creating new thread I messed another thread

This may be small question for Guru's . But I do have a question , Is there any advantage to recreate indexes with same extents and same size etc., and if I delete a row in a table will it be effected in index too ???


Raghu

[marist89]

Sure there is an advantage. When oracle deletes a row from a table, the row is deleted for the index but the space for that index entry still remains. If you have an index for a table that has had a lot of deletes, it will compact your index blocks.

[raghud]

Thanks for the info.. Can I get the scripts to find out and recreate indexes on a schema ..
I am using imp with indexfile= ....... option . It got lot of manual work . Please get me some scripts if you have ..

Raghu

[pando]

may be this link is what you are looking for


Setting Up an Automated Index-Rebuilding System

http://www.oracle.com/oramag/webcolu...uto_index.html

[raghud]

Great information .. Thanks for all


Raghu