SQL Server: Script to find a Table which has more than 10 Indexes

In this post, I am sharing one T-SQL script to find a Table which has more than 10 Indexes in SQL Server.

More Indexes on a Table, are creating a performance issue because Indexes also require dedicated CPU I/O for writing it into the Index Pages.
More Indexes will slow down the insertion or any other DML operation of that particular Table.

Below is a script to find out tables which are having more indexes:
You can change the value of @threshold.

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz