How to see if there are statistics available on an object in oracle database? If they are available, how do know if they are stale or not. Are there any views to get this information?
Could anybody please also let me know if there is a view to see if an index is unselective or not. I mean I would like to see how often the index is being used.
Your input is greatly appreciated.