Do we need to rebuild indexes after insert /*+APPEND
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Do we need to rebuild indexes after insert /*+APPEND

  1. #1
    Join Date
    Feb 2001
    Posts
    128

    Do we need to rebuild indexes after insert /*+APPEND

    Hi,

    I'm loading a large table with Insert /*+APPEND, the table has many indexes on it. Do I have to rebuild the indexes after the load or will they adjust automatically.

    Thanks
    Jay

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Perform an insert /*+ append */ and see if the indexes are rendered unusable according to the user_indexes table.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Feb 2001
    Posts
    128
    I did a small test, they are in VALID state, but would I still need to (or have to) rebuild them?

    Thanks
    Jay

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Nope. you'd rebuild them as a solution to a well-defined performance problem or to move them to a new tablespace, but otherwise leave them be.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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