An index speeds one path and adds work to another

An index can reduce rows examined for a selective lookup, but each insert or update may also need to maintain it, and the index uses storage. Check the actual query shape and data distribution before adding one; an index that is never useful still has a write and storage cost.