The following design document indexes can be referred to as an example:
|
Index name |
Unique |
Columns (in order) |
|---|---|---|
|
PK_<PREFIX>OBJ |
Yes |
OBID |
|
IDX_<PREFIX>OBJ |
Yes |
OBJUID CONFIG DOMAINUID TERMINATIONDATE |
|
IDX_<PREFIX>OBJ_UKEY |
No |
UNIQUEKEY |
|
IDX_<PREFIX>OBJ_DUID_CFG_TD_UPNAM |
No |
OBJDEFUID DOMAINUID CONFIG TERMINATIONDATE OBJNAME |