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?
    
asked Oct 13, 2015 by mca.agarwal
0 votes
1 view



Related Hot Questions



Government Jobs Opening


...