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.