how to identify the indexes which not used In the past year and drop it
Dears,
we are in oracle database 11.2.0.4.0, our index table space is very huge, almost the same size with the data table space,so i think there must be some indexes are not used, could you pls tell me how to identify the unused indexes? then i want to drop it.
Thank you
Bruce