Create Hash-Partitioned Global Index

Create Hash-Partitioned Global Index example

  
-- create Hash-Partitioned Global Index
CREATE INDEX stu_last_name_idx ON STUDENTS_LIST (LAST_NAME)
  GLOBAL PARTITION BY HASH (LAST_NAME)
  PARTITIONS 2;

Output:

index STU_LAST_NAME_IDX created.

Check indexes

select INDEX_NAME, INDEX_TYPE, PARTITIONED
from USER_INDEXES
WHERE table_name='STUDENTS_LIST';  

Output:

INDEX_NAMEINDEX_TYPEPARTITIONED
STUDENT_IDXNORMALNO
STU_LAST_NAME_IDXNORMALYES