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