Rebuild partition index in parallel
INDEX_NAME LAST_ANALYZED DEGREE STATUS
------------------------------ -------------------- ---------------------------------------- --------
EB_RDG_IDX2 08-OCT-2013 20:28:43 1 N/A
EB_RDG_IDX3 08-OCT-2013 20:28:48 1 N/A
EB_RDG_IDX4 08-OCT-2013 20:28:53 1 N/A
EB_RDG_IDX5 08-OCT-2013 20:28:58 1 N/A
EB_RDG_IDX6 08-OCT-2013 20:29:02 1 N/A
EB_RDG_IDX1 08-OCT-2013 20:29:03 5 VALID
I want to rebuild indexes, 5 indexes are local indexes. Each local index only has 3 partitions, I only need rebuild one partition of 3.
Should I run these scripts to do rebuild partitioned indexes?
alter index energydb.EB_RDG_IDX2 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;alter index energydb.EB_RDG_IDX3 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;alter index energydb.EB_RDG_IDX4 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;alter index energydb.EB_RDG_IDX5 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;alter index energydb.EB_RDG_IDX6 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;After I rebuild index in parallel 8, should I change the parallel degree into 1? How to do this?Thanks,