Results 1 to 3 of 3

Thread: Rebulid Index

  1. #1
    Join Date
    Apr 2003
    Posts
    17

    Unanswered: Rebulid Index

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

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    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>

  3. #3
    Join Date
    Apr 2003
    Location
    Germany
    Posts
    25

    Re: Rebulid Index

    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

Posting Permissions

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