Database | Recommendations

Shows tables with no primary key, tables with no clustered index, and foreign keys with no supporting index.

Tables with no primary key

What It ShowsComments
TableNearly all tables should have a primary key. A possible exception would be a table used as intermediate storage during a data load

Tables with no clustered index

What It ShowsComments
TableIn general, having a clustered index generally outperforms a table without. It is also not possible to defragment a heap, so index maintenance is easier with clustered indexes.
RowsThe number of rows in the table

Foreign keys with no supporting index

This is not always a bad thing - there is no point maintaining an index that is never used. However, some queries may generate more efficient execution plans if an index is present for a foreign key column.

What It ShowsComments
Table
Column
Constraint
< Database | Tables Database | Indexes | Missing >