On Wednesday, September 20, 2023, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
wrote:
>
> Why unique index is used over unique constraints?
>
It’s rare that you would. Occasionally people want to enforce uniqueness
over a subset of the table - like if you want to ensure a maximum of one
active record (for a given id) at any given time but allow for multiple
historical records (for the same id) on the same table.
David J.