[转载]Oracle创建、重建和删除索引

 

创建索引：

SQL> create index mcconf_index onmc$ma_warn_config (NAME);

Index created.

SQL> select owner,object_name from all_objectswhere object_type='INDEX' and object_name='MCCONF_INDEX';

OWNER                          OBJECT_NAME

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

MEGATRUST                      MCCONF_INDEX

重建索引：

SQL> alter index mcconf_index rebuild;

Index altered.

删除索引：

SQL> drop index mcconf_index;

Index dropped.