I've recently found a few queries in my slow query log that should have been using indexes. When investigating the indexes in phpmyadmin it shows a null or empty cardinality. I'm unsure what causes this, but I need to find a way to identify this problem without manually checking 200+ tables.
Is there a script or a query that I can use to find these "corrupt" indexes? If so can I force a rebuild of the index?