[Script of Jul. 11] Check database indexes issues (T-SQL)

  • Article

Script Download: CheckIndexesIssues.zip
https://gallery.technet.microsoft.com/scriptcenter/Check-database-indexes-b9a19d0f

This script will demonstrate how to list all the tables in a database with following situations:

  • Tables with no index
  • Tables with no clustered index but with non-clustered index
  • Tables with more indexes than columns 

We provide this script for people to reference. If someone wants to know tables with no index or clustered index, or tables with more indexes than columns, this script will provide some help.

image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery