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