Answer
Common indexing mistakes include:
- Too many non-clustered indexes
- Lack of covering indexes for hot queries
- Poor clustered key choice (wide, GUID, non-sequential)
- Duplicate or overlapping indexes
- Not using filtered indexes
These increase I/O, fragmentation, and reduce plan efficiency.