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

原文地址：Oracle创建、重建和删除索引作者：松风竹影

创建索引：

SQL> create index mcconf_index on mc$ma_warn_config (NAME);

Index created.

SQL> select owner,object_name from all_objects where 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.