Table & columns with no Indexes

<< Click to Display Table of Contents >>

Navigation:  View Indexes > Examples Usage >

Table & columns with no Indexes

In the tree a check box is only displayed when one of these conditions is met


At the table level there is an index on table

At the column level there is an index on the column.



If there is no check box this means there is no index on the table and/or column.


Sort by the column Index Clustered Index to identify tables with no clustered index.


In the Example below


The dbo.HeapTable does not have an index- meaning the table storage is a HEAP

The HumanResources.Department table has a check box on the table meaning there are indexes on the table. The GroupName and ModifiedDate columns do not have any indexes on those columns.