B-tree index

B-tree index example

CREATE INDEX student_idx
   ON STUDENTS_LIST (student_id);

Output:

index STUDENT_IDX created.

Check index

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

Output: