Create Index with Collect Statistics

Create Index with Collect Statistics example

  

-- create Index with Collect Statistics
CREATE INDEX stu_ln_idx 
  ON STUDENTS_LIST(LAST_NAME)
     COMPUTE STATISTICS;

Output:

index STU_LN_IDX created.

Check index

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

Output:

INDEX_NAME	INDEX_TYPE	TABLESPACE_NAME
STU_LN_IDX	NORMAL	SYSTEM

↑