Unique vs sparse vs partial indexes: what’s the difference?

Answer

A unique index enforces uniqueness for indexed documents. A sparse index only includes documents that have the indexed field. A partial index includes documents matching a filter expression. You can combine them to enforce uniqueness only for a subset of documents.