||SQL Server Tips by Burleson
This book is not designed for those who are new to SQL Server, so
the general indexing discussions that focus on what an index is, the
types of indexes, etc. will be bypassed. Instead, this section will
explain how best to index for performance. Keep in mind that each
database’s workload is different, but the following checklist can be
utilized when reviewing a new or existing physical design:
Is it known which indexes are and are
not being used?
Do all key tables have a clustered
Have the foreign keys been indexed?
Have the DML effects on each table been
Is each index’s uniqueness strong enough
to be useful?
Is each index’s fillfactor set properly?
Is there an index maintenance plan in
The above book excerpt is from:
High-Performance SQL Server DBA
Tuning & Optimization Secrets