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 |