-
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
-
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.
-
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
-
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
-
Great information .. Thanks for all
Raghu