Oracle PL/SQL/System Tables Views/user indexes

Check query in user_indexes after creation

   <source lang="sql">
   

SQL> SQL> create table emp(

 2           emp_id                integer         primary key
 3          ,lastname               varchar2(20)    not null
 4          ,firstname              varchar2(15)    not null
 5          ,midinit                varchar2(1)
 6          ,street                 varchar2(30)
 7          ,city                   varchar2(20)
 8          ,state                  varchar2(2)
 9          ,zip                    varchar2(5)
10          ,shortZipCode                   varchar2(4)
11          ,area_code              varchar2(3)
12          ,phone                  varchar2(8)
13          ,company_name           varchar2(50));

Table created. SQL> SQL> SQL> create index emp_2_idx_phone on emp (phone); Index created. SQL> SQL> select index_name, table_name, uniqueness

 2    from user_indexes
 3   where index_name = "EMP_2_IDX_PHONE";

SQL> SQL> drop table emp; Table dropped. SQL>

 </source>
   
  

Did the command create index statistics?

   <source lang="sql">
   

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.

 </source>