recreate indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: recreate indexes

  1. #1
    Join Date
    Aug 2001
    Posts
    267
    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
    Raghu

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2001
    Posts
    267
    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
    Raghu

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  5. #5
    Join Date
    Aug 2001
    Posts
    267
    Great information .. Thanks for all


    Raghu
    Raghu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width