130821创建索引

 
SQL> create table calvin.customers as select * from store.customers;
 
Table created

 
SQL> CREATE index customers_last_name_idx on customers(last_name);
 

Index created

创建样例表和样例索引；

SQL> select index_name, table_name, uniqueness, status from user_indexes where table_name in ('CUSTOMERS');
 
INDEX_NAME                     TABLE_NAME                     UNIQUENESS STATUS
------------------------------ ------------------------------ ---------- --------
CUSTOMERS_ID_PK                CUSTOMERS                      UNIQUE     VALID
CUSTOMERS_LAST_NAME_IDX        CUSTOMERS                      NONUNIQUE  VALID
 

修改名字； 

SQL> alter index CUSTOMERS_LAST_NAME_IDX RENAME TO CUSTOMERS_LAST_NAME_IDX1;
 
Index altered

删除；

  
SQL> drop index customers_last_name_idx1;
 
Index dropped