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.