-
Slow Index Creation
Hi all,
I am doing the migration using exp & imp utility. However, I manual create the index & it took so long to create the index on 3 x 2GB tablespace. What should I do in order to improve the index creation performance?
Please advice.
Thanks
-
Build lots of indexes at the same time, using the PARALLEL and NOLOGGING keywords, and setting a reasonably large sort_area_size.
-
Re: Slow Index Creation
Originally posted by samc
Hi all,
I am doing the migration using exp & imp utility. However, I manual create the index & it took so long to create the index on 3 x 2GB tablespace. What should I do in order to improve the index creation performance?
Don't use exp/imp to migrate.
Jeff Hunter
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
|