I want to move some indexes to another tablespace. For that I am using the below SQL:
ALTER INDEX xyz REBUILD TABLESPACE TS_INDX01 NOLOGGING PARALLEL 8;
I am using NOLOGGING and PARALLEL thinking it will speed-up the movement process. But now I am confused because I think it will change the property of the index also, as in, when we create an index we specify some parallel and logging properties.
So I want to understand:
1. Will the above SQL change the properties of the index?
2. How can I view the existing nologging and parallel properties of an index?