Yes, in PG at least an index is created, otherwise the unique check would become... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

jimktrains2 on Jan 2, 2018 | parent | context | favorite | on: SQL Keys in Depth

Yes, in PG at least an index is created, otherwise the unique check would become prohibitive.

cheapsteak on Jan 2, 2018 [–]

I think the question is more on whether a duplicate index would be created instead of having the unique constraint and primary key designation on the same column share an index

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact