Index Rebuild and Import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Index Rebuild and Import

  1. #1
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409

    Index Rebuild and Import

    I know Index rebuild is generally a bad idea, but is it advisable to do it, after full import of a schema objects along with data.

    Thanks for any inputs.
    -- Dilip

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    the thing is, after import your indexes are brand new so why rebuild them when they are new

  3. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Thanks Pando. I asked coz the database I have inherited, has a checklist to be followed after the import procedure and this step being one of them.
    -- Dilip

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Why is index rebuilding a "bad idea", if you can do it periodically without any impact it can be a good thing.

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    MH, is this a troll ???
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    Hmmm. I don't think so, don't we have pretty good troll control here?

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    Jun 2000
    Posts
    295
    How can an index rebuild without any impact?
    Rebuilding an indexes needs resource such as
    lock and CPU times.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Use online rebuild to circumvent locking issues. True, rebuilding index takes CPU time, but everybody has enough of that, right?
    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."

  9. #9
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by sysdba
    How can an index rebuild without any impact?
    Rebuilding an indexes needs resource such as
    lock and CPU times.
    To the users Beavis, to the Users. C'mon cut me some slack here, with that theory you can not do anything on the DB.

    MH
    I remember when this place was cool.

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