Indexes

Designing Indexes
Finding Indexes

Index Usage

Index Usage can be seen from system table sys.dm_db_index_usage_stats which is explained in detail here.

Managing Indexes

XML Indexes