Outbound and inbound message queues in ServiceNow requires indexes to be added in order for Replicator to function optimally. The following table documents all the tables and the indexes that need to be created by an administrator of your ServiceNow instance.
To create a table index, refer to index creation guideline for ServiceNow.
| Table | Index Name | Type | Fields |
|---|---|---|---|
| PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message) | psp_out_query | composite, non-unique | State (state) Target Queue (u_target_queue) Created (sys_created_on) |
| PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message) | psp_out_query3 | single, non-unique | Sequence (u_sequence) |
| PSP Out Message tables (psp_out_message, u_psp_attachment_out_message, u_psp_audit_out_message, u_psp_observer_out_message) | psp_out_query4 | composite, non-unique | Created (sys_created_on) Sequence (u_sequence) |
| PSP In Message (psp_in_message) | psp_in_query | single, non-unique | Created (sys_created_on), name, key, u_sequence |
| PSP In Message (psp_in_message) | psp_in_query2 | single, non-unique | State (state) |
| PSP Log Message (u_psp_log_message) | psp_log_query | single, non-unique | Created (sys_created_on) |
| PSP Log Message (u_psp_log_message) | psp_log_query2 | composite, non-unique | Created (sys_created_on) Type (u_type) |
| PSP Properties (u_psp_properties) | u_psp_properties_u_name | single, non-unique | Name (u_name) |
| PSP Replicate Conf (u_psp_replicate_conf) | u_psp_replicate_conf | single, non-unique | active, sync_direction, table_name |
