|
-
Okay, I can see how the ddl is save. But to continue the thought, what about if the indexes are dropped? That is my next test. Would that reduce my import time and file size? That index data is stored somewhere.
I am going to turn the statistics off as well. Once we do the migration, we are going to be modifying quite a few of the objects and creating new objects. We plan to do a schema analyze as a last step so stats will be taken care off.
Thanks for the info so far...
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
|