In the Indexing best practices

Here is another avoid

Avoid using fields in indexes that are updated frequently.

Status fields are a prime example. Each time the field is updated the index has to be updated.

This is a major cause of deadlocking on the index structures of one application where I am currently employed and has caused me endless grief.

There are 6 different statuses as the record proceeds through our system and a dashboard watches it real time from created, validated, ready, processing, sent, complete. Each time causes the index to be updated as well.