any table with atleast one index can be queried for index stats usage to identify if the table is being actively used or not
how to identify if heaps are being actively used by applications or not
we have thousands of heaps and most of them are just temporarily created , how we we know which ones are real and are being used by applications if no index is there