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_NAME	INDEX_TYPE	PARTITIONED
STUDENT_IDX	NORMAL	NO
STU_LAST_NAME_IDX	NORMAL	YES

↑