Rebuild Index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Rebuild Index

  1. #1
    Join Date
    Oct 2001
    Posts
    127
    What is the difference between Rebuild Indexes and dropping and recreating the indexes.Are these same ?
    Thanks

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Yes it does the same.

    The rebuild clause drops the original index when the rebuild is completed ie when the new index is created.

    Regards
    Santosh

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    When u delete or update a record in a table the corresponding index data in the index will not delete or updated instead for an update, a new record will be inserted in the index and rebuild will remove all those records that do not match with the table records and also rebuild will not remove an fragmentation in the index segment.But you can de-fragment the index segment when u drop and recreate with appropriate storage parameters.

    cheese
    anandkl
    anandkl

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Rebuild can be used to create the index in a different tablespace with different storage parameters and it can be used with parameter

    online

    in which case the index is still accessable.

    Regards
    Santosh

  5. #5
    Join Date
    Feb 2001
    Posts
    290
    To my understanding , fragmentation will be eliminated in both the ways, Rebuild of index will use the existing index and hence it is much faster and needs much space on the disk.

    well dropping is also a good thing, just like starting from fresh , but its a time consuming process, sometimes u are not affordable to do it.

    Rebuild with NOLOGGING (no REDO will be generated ) is much faster way of creating the index, incase of failure of Index creation , u always will have the old, existing one.


  6. #6
    Join Date
    Oct 2001
    Posts
    127
    Thanks a lot for valuable suggestions.

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