Index usage for a table

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.

Leave a Reply

Your email address will not be published. Required fields are marked *