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_NAMEINDEX_TYPETABLESPACE_NAME
STU_LN_IDXNORMALSYSTEM