Creating indexes on columns where primary key or unique key constraints already present Creating indexes on columns where primary key or unique key constraints already present oracle oracle

Creating indexes on columns where primary key or unique key constraints already present


At the very least, if you create an index explicitly, you can give it a meaningful name. If you then need to refer to the index by name, it will be in a human-readable form.

Note that you can create an explicit index WHILE you are creating the constraint, in the USING INDEX clause. The documentation has a few examples: https://docs.oracle.com/cd/B28359_01/server.111/b28310/indexes003.htm#ADMIN11725


The only idea I have is those automatically created indexes got some weird names either generated as SYS% or inheriting names from constraint name. It is probably better to keep some naming convention for indexes