On Wed, 2023-09-20 at 19:16 +0530, Rajesh Kumar wrote: > Why unique index is used over unique constraints? A unique constraint is implemented by a unique index. If you create the constraint, the index is created automatically. You cannot drop the index unless you drop the constraint. Yours, Laurenz Albe