Under What Conditions Can Adding A Primary Key Constraint Not Create An Index?
Last updated on JUNE 16, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Normally whenever we create any primary key on any table then it is enforced using unique index, however this note explains the case where adding primary key doesn't add any new index on table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms