This audit can be constructed in many RDBMS. In SQL Server tracing there is warning for missing foreign key indexes needed for query plans, and stats are also kept for indexes so you can tell if the indexes are needed/used. I have a smorgasbord of audits to run on a server/database/schema to expose poor construction.