Rebuild indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Rebuild indexes

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    Is there any disadvantage to rebuild all user indexes lets say everynight ( Off peak time ) ???

    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    well, it's not needed ... I mean Oracle manages it's indexes alone, rebuild is more used to unfragment or to move indexes, but except the fact that it consumes time and CPU resources, there is no problem in doing that ... if you have no query running of course

  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Exclamation


    Why would you want to if they are not defragmented?
    If you do not have activity overnight, then I suppose there is no problem doing it if you want.

    - Magnus

  4. #4
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    I'm not aware of any as long as the rebuilds are complete before the workload on the database increases (so not to impede performance)

    What version of Oracle are you using? You may be able to generate your statistics on the rebuilt index online during the rebuild.

    Cheers
    Moff

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Sure there are negative implications. For example, all the cached blocks of the frequently used index will be flushed out of the buffer cache, resulting in decreased performance immediately after the index rebuild.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Should you analyze them weekly?

  7. #7
    Join Date
    Nov 2000
    Posts
    416
    We use 8.1.6. Do you have any scripts which first find out which indexes needs to be rebuild and then issue rebuild commands. Sounds like this is a better approach. Please post the script.

    Also what happen if several queries issues in the middle of rebuild ?? Chances of Halt or Hang ??
    An ounce of prevention is worth a pound of cure

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Not much possibility for hang, it would only lead to a slow down. "Virtual" hang.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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