Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Did the command create index statistics

SQL> SQL> SELECT index_name   2  FROM user_indexes   3  WHERE last_analyzed IS NULL; INDEX_NAME ------------------------------ SYS_C004799 SYS_C008156 HD_CLUSTER_INDEX 3 rows selected.