how to rebuild indexs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: how to rebuild indexs

  1. #1
    Join Date
    Feb 2006
    Posts
    34

    how to rebuild indexs

    Please tell me how to rebuild the indexes. some of my index ts is 3 GB or more than that. This one need to schedule or we can do it during office hrs. I have no idea on this. please give me some ideas on this.

    Regards.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    How you do it? Easy, just ALTER INDEX xyz REBUILD.

    The bigger question, though, is why would you want to do it? If you are just rebuilding indexes because you think it's a good idea to periodically do it, then think again.
    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
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    To further what Jeff said here is a post from asktom , When to rebuild indexes.

    This topic has been beaten to death pretty well.
    this space intentionally left blank

  4. #4
    Join Date
    Dec 2006
    Location
    hyderabad
    Posts
    21

    rebuilding indexes

    You could also go for rebuilding indexes online

    e.g: alter index xyz rebuild online;

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Quote Originally Posted by girirajdba
    You could also go for rebuilding indexes online

    e.g: alter index xyz rebuild online;
    Perhaps you missed something. You do not need to rebuild indexes unless there is a problem with an index or you want to move it to a different tablespace. So it does not matter if you rebuild online or not!!!!
    this space intentionally left blank

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    is that a bitmap index?.. where size grows significantly (IMHO of such a behaviour).. and after rebild u can claim as much as 2.5GB..
    Last edited by abhaysk; 01-17-2007 at 01:55 AM.

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