1.多列建立索引

SQL> create index dex_index2 on dex(sex,name);

Index created.

SQL>  select object_name,object_type from user_objects;

OBJECT_NAME                           OBJECT_TYPE

--------------------------------------------------------------------------------

DEX                                       TABLE

DEX_IDX1                                 INDEX

DEX_INDEX2                               INDEX

2.删除索引

DROP INDEX [schema.]indexname