Create Explicit Index

Create Explicit Index example

  

-- create Explicit Index
CREATE INDEX last_name_idx 
  ON STUDENTS_LIST(LAST_NAME)
      TABLESPACE SYSTEM
      STORAGE (INITIAL 10K
      NEXT 10k
      PCTINCREASE 75);

Output:

index LAST_NAME_IDX created.

Check indexes

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

Output:

INDEX_NAME	INDEX_TYPE	TABLESPACE_NAME
STUDENT_IDX	NORMAL	SYSTEM
LAST_NAME_IDX	NORMAL	SYSTEM

↑