【Oracle】建立索引

来源:互联网 发布:av5644769只有我知 编辑:程序博客网 时间:2024/05/17 02:53


/**    * 建索引 */DECLARE AN_FLAG NUMBER;BEGINSELECT COUNT(1) INTO AN_FLAG FROM USER_IND_COLUMNSWHERE TABLE_NAME = 'T_ZZ_RELEASED_RECORD'AND COLUMN_NAME = 'RR_ID';IF AN_FLAG = 0 THEN    EXECUTE IMMEDIATE 'CREATE INDEX IDX$RR_ID ON T_ZZ_RELEASED_RECORD(RR_ID)';    COMMIT;  END IF; END;/


0 0
原创粉丝点击