Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
advantage of a unique index in mongodb
advantage of a unique index in mongodb ¬†using -'mongodb,unique-index,mongodb-indexes'
I've tried to search through Mongo documentation, but can't really find any details on whether queries on unique indexes will be faster than queries on non-unique indexes (given the same data)
So I understand that a unique index will have high selectivity and good performance. But, given two fields whose concatenation is unique, would a non-unique compound index perform slower than a unique compound index?
I am assuming that unique indexes can slow down inserts as the uniqueness must be verified. But is the read performance improvement of a unique index, if any, really worth it?
Oct 13, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening