【oracle11g ，19】索引管理

    隐藏索引变正常索引或反之 sys@TESTDB> alter index scott.emp_ename_i visible;   Index altered.   scott@TESTDB>  select index_name,VISIBILITY from user_indexes;   INDEX_NAME                     VISIBILIT ------------------------------ --------- PK_EMP                         VISIBLE EMP_SAL_F                      VISIBLE EMP_COMM_I                     VISIBLE EMP_ENAME_I                    VISIBLE PK_DEPT                        VISIBLE     多个索引，把慢的索引隐藏点，让他走快的索引     scott@TESTDB> alter index emp_ename_i visible;   Index altered.   scott@TESTDB> alter index emp_ename_i invisible;   Index altered.