Here is a simple query that will list every index on every table in your database, ordered by the percentage…