Oracle_J_添加索引

 1 DECLARE
 2    i_exists   NUMBER;
 3 BEGIN
 4    SELECT COUNT (*)
 5      INTO i_exists
 6      FROM all_indexes
 7     WHERE     TABLE_NAME = 'REPORT_DETAIL_UNAUDIT'
 8           AND INDEX_NAME = 'IX_REPORT_DETAIL_UNAUDIT_ITEM';
 9 
10    IF i_exists = 0
11    THEN
12       EXECUTE IMMEDIATE 'CREATE INDEX IX_REPORT_DETAIL_UNAUDIT_ITEM
13        ON REPORT_DETAIL_UNAUDIT (ITEM_ID)
14        TABLESPACE LIS_SPACE';
15    END IF;
16 END;
17 
18 COMMIT;

 

转载于:https://www.cnblogs.com/yuan1/p/5363142.html