查看某索引是否使用过
创建测试表及索引
SQL> drop table yallonking;
Table dropped.
SQL> create table yallonking as select rownum id,'yallonking' name from dual connect by rownum<1000;
Table created.
SQL> create index idx_id on yallonking(id);
Index created.
（一）通过对索引的监控来检查
SQL> alter index idx_id monitoring usage;
...