-
Index rebuild - Direct-path
Hello,
I am planning to rebuild few indexes in our production system.
Example:
>alter index "ZXML_IAM_EMAIL~0" rebuild online parallel 8 nologging compute statistics;
Also I heard that we can use the Direct-path operations (no rollback/undo generated) to rebuild an index.
How can I use the Direct-path option in the above Index rebuild sql statement?
Thanks,
Nikee
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
|