I just wrote a script that looks for tables with declared indexes that aren't actually implemented (it's basically just a wrapper around grep), and it found a few but there may be more as it's not very precise