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.
Printable View
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.
the thing is, after import your indexes are brand new so why rebuild them when they are new :D
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.
Why is index rebuilding a "bad idea", if you can do it periodically without any impact it can be a good thing.
MH
MH, is this a troll ???
Hmmm. I don't think so, don't we have pretty good troll control here?
MH
How can an index rebuild without any impact?
Rebuilding an indexes needs resource such as
lock and CPU times.
Use online rebuild to circumvent locking issues. True, rebuilding index takes CPU time, but everybody has enough of that, right? :p
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.Quote:
Originally posted by sysdba
How can an index rebuild without any impact?
Rebuilding an indexes needs resource such as
lock and CPU times.
MH