`
MicroJoey
  • 浏览: 85971 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

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 a
WHERE index_name IN ('SYS_C0098887','IDX_NAME');

ALTER TABLE tab01 MOVE;

INSERT INTO tab01
SELECT object_id,object_name FROM user_objects
WHERE object_id IS NOT NULL;

INSERT INTO tab01
SELECT 1,'a' FROM dual;

INSERT INTO tab01
SELECT 2,'b' FROM dual;


ALTER INDEX SYS_C0098885 REBUILD;

CREATE INDEX idx_name ON tab01(name);

SELECT * FROM tab01;

UPDATE tab01
SET 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.




分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics