This script helps us to understand the index on a particular table their usage and size occupied.
Execute the script by providing the tablename
Find Script Here IndexUsage
We can decided whether to drop index based on user_seeks and user_updates.
KeyColumns helps us understand if multiple indexes are created on similar columns.