Finding useless indexes

(Arjen Lentz) I’ll say beforehand that the following is not very clean – for a number of reasons. I’ll discuss some issues after the query. The query returns all indexes in a db where the cardinality is lower than 30% of the rows, thus making it unlikely that the server will ever use that index.

Read More - Register for Free Membership