Set Index Parallel

Set Index Parallel example

In Oracle database to set an index parallel you must use the command alter index with REBUILD PARALLEL keyword.

  

-- set Index Parallel
ALTER INDEX STU_LN_IDX
   REBUILD
   PARALLEL;

Output:

index STU_LN_IDX altered.

Check indexes

select INDEX_NAME, DEGREE, INSTANCES 
from USER_INDEXES 
WHERE TABLE_NAME='STUDENTS_LIST';

Output:

INDEX_NAME	DEGREE	INSTANCES
STUDENT_IDX	1	1
STU_LN_IDX	DEFAULT	DEFAULT

↑