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_NAMEDEGREEINSTANCES
STUDENT_IDX11
STU_LN_IDXDEFAULTDEFAULT