Been recently playing around with MongoDB and its indexes within a sharded environment. Taking this into account I wanted to make some tests within my local DB and see how writes are affected by indexes.
I’ve got a collection with 2 indexes, one is used for the reading side of things and the other one was used in the sharded cluster.
Having a hashed index which was used for sharding in a single cluster environment infers a penalty when writing or any other kind of issue, should I remove it? It’s not an unused index, that’s for sure!