python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - unique-index

Is any performance enhancement when we used Unique index instead of non Unique index?

I know a unique index will be faster than a non unique index theoretically if data is unique. Because a unique index is able to provide more information and let the query optimizer choose more effecti...
test-img

D-Shih

postgresql

indexing

sql-execution-plan

unique-index

Votes: 0

Answers: 1

Latest Answer

An unique index won't be any faster to scan than a non-unique one. The only potential benefit in query execution speed could be that the optimizer can make certain deductions from the uniqueness and f...
test-img

Laurenz Albe

Posts

Questions

Blogs

Jobs