Check SQL Server Index Fragmentation Here are few simple queries that will list every index on every table in your…