What classes and methods could you point me to such that I could log the index ultimately used by the optimizer?
My objective is to identify useless and extraneous indexes in the database. I would like to capture a list of indexes used by the database while it is in use by an application over a period of time. Comparing the list against ALL the indexes created in the system should provide a starting point for identifying extraneous indexes. Alternatively, perhaps one might recommend enabling a logger class that outputs this information already. Enabling logQueryPlan is my least favorite idea, because of its verbosity. I'm open to other ideas too. Thanks. Mark -- View this message in context: http://apache-database.10148.n7.nabble.com/Logging-indexes-used-by-queries-tp128355.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.
