读书人

Will the valid status of index imp

发布时间: 2012-07-02 17:46:22 作者: rapoo

Will the valid status of index impact dml operation?

DROP TABLE tab01;SELECT * FROM tab01;CREATE TABLE tab01(ID NUMBER NOT NULL PRIMARY KEY,NAME VARCHAR2(50));SELECT index_name,a.status FROM User_Indexes aWHERE index_name IN ('SYS_C0098887','IDX_NAME');ALTER TABLE tab01 MOVE;INSERT INTO tab01SELECT object_id,object_name FROM user_objectsWHERE object_id IS NOT NULL;INSERT INTO tab01SELECT 1,'a' FROM dual;INSERT INTO tab01SELECT 2,'b' FROM dual;ALTER INDEX SYS_C0098885 REBUILD;CREATE INDEX idx_name ON tab01(name);SELECT * FROM tab01;UPDATE tab01SET NAME='aaaa'WHERE NAME ='SRC_PROV';



Conclusion:
1,if primary key related index will impact dml operations
2,others indexes do not impact the dml operations.




读书人网 >其他数据库

热点推荐