Partial Indexes are a way to create indexing on a partial data set of a table which satisfies the given logic. when these combined with unique indexes it can helps in adding conditional unique constraints on a table. Conditional unique constraints can help in avoiding duplication of records becasue of various concurrent duplicate requests