Verifying Sql Indexes Status

Karthik Puppala
Aug 29 2014
1.2k
0
0

Select * from sys.indexes
where object_id = (select object_id from sys.objects where name = 'TABLENAME'

This query will list all tables without an index:

Select * from sys.indexes where object_id = (select object_id from sys.objects where name = 'MYTABLE')

Up Next

SQL

Verifying Sql Indexes Status