cannot create index (tablename, sys_created_on) on sys_audit_delete table.

[stephane9]

The issue is that I cannot create index (tablename, sys_created_on) on sys_audit_delete table.

I need this to fix an issue linked to performance and checking the sys_audit_delete table, I already have an index for both tablename and for sys_created_on but I don't have an index for  (tablename, sys_created_on).

When selecting to create a new index, I get the option to select tablename but not sys_created_on (either first or second choice after selecting tablename) , thus I can't create the  (tablename, sys_created_on)  index.

I am not sure what to do or why sys_created_on is not visible ( it's not configured differently from tablename index)

[ServiceNow Tec2 · Accepted solution]

This has been resolved by ServiceNow Technical Support. Please refer to KB1006305 for more information.