Did the command create index statistics? : user_indexes « System Tables Views « Oracle PL / SQL






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.

   
    
    
    
  








Related examples in the same category

1.Check query in user_indexes after creation