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