Re:SQL Keys in Depth
by jimktrains2 on Tuesday January 02, 2018 @12:11PM
(#16053276)
Yes, in PG at least an index is created, otherwise the unique check would become prohibitive.
[ Parent
| on HN ]
Re:SQL Keys in Depth
by cheapsteak on Tuesday January 02, 2018 @01:53PM
(#16054279)
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