-
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
-
the thing is, after import your indexes are brand new so why rebuild them when they are new
-
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
-
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.
-
Amar
"There is a difference between knowing the path and walking the path."
-
Hmmm. I don't think so, don't we have pretty good troll control here?
MH
I remember when this place was cool.
-
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?
Jeff Hunter
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|